[BigSnooze]

SOLVED!!

Noticed that the password for my root user was visible in the user table in mysql database, whereas it was encrypted in databases I could connect to.

Experimented by creating a new user with no password and was able to connect.

Issued this command…

GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY “password” WITH GRANT OPTION;

Viewed user table and the root password was now encrypted, restarted mysql service and it worked.

I have since found that when creating a new user with INSERT that the command 'FLUSH PRIVILEGES' is then needed so maybe this is why it didn't work.

Thanks for all your assistance.

[BigSnooze]

RE;- Could you try to create a 'root'@'myPChostname.mydomainname” (if possible) and/or a 'root'@'myPChostname”.

Nope, none of these worked.

[BigSnooze]

Thanks again for the reply.

I have added a row in the mysql user table granting all privileges to the User root at Host % with the correct password and restarted mysql.

Error is now 1045. Access denied for user 'root'@'myPChostname.mydomainname” (using password: YES)

1) Is your MySQL server and SQLyog installed in the same machine ?

> No, server is on a newly built Linux box, SQLyog (Already installed and working fine)on my XP machine.

2) Can you please explain in details how you are connecting to your MySQL server?

You may provide us with a screenshot of SQLyog connection window.

> This will have to follow, USB connection on my PC broken so can't transfer screenshot just yet.

3) Are you able to connect using IP address instead of “hostname”

> No difference if I use IP address.

[BigSnooze]

Sorry, got totally mixed up. Have now commented out bind-address in my.cnf and now back to original error 1130

[BigSnooze]

Thanks, but had already looked at this. I commented out bind-address in my.cnf. I don't think that there is a Firewall or similar issue because I have several other connections already working with SQLyog.

[BigSnooze]

Thanks for the reply.

The error has now changed to Error No. 2003 Can't connect to MySQL server on 'localhost' (10061) but I don't know what I've done to cause this. There is an entry in my hosts file for the linux box with the correct IP address. Don't know if its HTTP or SSH, how would I tell?

[Author]

Posts