April 24th, 2004, 06:40 PM
Join Date: Dec 2003
Time spent in forums: < 1 sec
Reputation Power: 0
Error 1130, remote connecting access denied
I run mysql on a Linux server - installed MySQL Control Center in my Win2k computer and got that error message as soon as I tried to connect.
The way to correct this problem is to simply add an entry to the user table in the MySQL database.
You can do this through PhpMyAdmin if you have that available on the server, or you can do it through the server's command line.
One thing to keep in mind: I believe the password field needs to be inserted (or updated) through the command line, because account name passwords are not stored in plain text, but as a hash value computed from it.
So after inserting an entry with my PC's name as the hostname value, I did this through the server's command line:
#> mysql -p
#> use mysql
mysql> UPDATE user SET password = password('yourpassword') WHERE hostname = 'whateveryourPCshostnameis';
One last thing - be sure to stop and start your mysql service after that.
#> service mysql restart
I was able to connect without any problems after that. I found that many people mentioned this problem in boards, but no one actually offered this solution.
Hopefully this helps someone with a similar configuration.
Last edited by lounatic77 : April 24th, 2004 at 08:15 PM.