Monday, 24 October 2011

Can't login to MySQL remotely !

Can't login to MySQL remotely !

Hi there I am using red hat enterprise 5.6 as the main (local) DB server, currently I am trying to access MySQL using MySQL query browser from a windows machine.

I keep getting an error as follows when I try to log in:
MySQL Error number 1045

I know the username and password is correct as I use these locally, also I can ping the RHEL server.

The port 3306 is also open and I have also issued the command:

Code:

GRANT USAGE ON *.* To 'root' at '<ipaddress>' IDENTIFIED BY '<root password>'
But this doesn't seem to work and I am now running out of ideas help me please !

Thanks in advanced.

No comments:

Post a Comment