mysql: can't connect from remote since restarted!

Shioni · 12-06-2006, 09:45 AM

Hi!
I had set up remote mysql access to my server:

Code:

grant all on *.* to 'root'@'10.1.10.190';

and set mysql to bind on my ip address in my.cnf:

Code:

bind-address = x.x.x.x

I restarted the mysql, and everything worked fine for a week, but after I restarted the server, the remote access doesn't work anymore. It's strange that if I do port scan from localhost on the server, there aren't mysql returned, but if I do mysql -u root,then it connects from localhost.

Code:

Interesting ports on localhost (127.0.0.1):
(The 1667 ports scanned but not shown below are in state: closed)
PORT   STATE SERVICE
80/tcp open  http

Nmap finished: 1 IP address (1 host up) scanned in 0.100 seconds

this is the error I'm getting:

Code:

ERROR 2003 (HY000): Can't connect to MySQL server on 'somesite.com' (111)

Any suggestions please? Thank you!

**EDIT** Never mind, I found the solution:
GRANT ALL ON *.* TO root@'10.1.10.190' IDENTIFIED BY 'PASSWORD';

trickykid · 12-06-2006, 11:26 AM

Perhaps the no-networking option was invoked with MySQL by default during the restart, which by default turns off remote networking access.