Results 1 to 3 of 3
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.
...
Enjoy an ad free experience by logging in. Not a member yet? Register.
- 10-24-2011 #1Just Joined!
- Join Date
- Aug 2011
- Posts
- 13
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:
But this doesn't seem to work and I am now running out of ideas help me please !Code:GRANT USAGE ON *.* To 'root' at '<ipaddress>' IDENTIFIED BY '<root password>'
Thanks in advanced.
- 10-24-2011 #2Trusted Penguin
- Join Date
- May 2011
- Posts
- 3,664
Can you temporarily try a wildcard definition, to see if that is your problem? e.g.:
Is there anything helpful in the mysqld.log?Code:GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY 'password';
- 10-24-2011 #3Just Joined!
- Join Date
- Aug 2011
- Posts
- 13


1Likes
Reply With Quote

