I had set up remote mysql access to my server:
grant all on *.* to 'root'@'10.1.10.190';
and set mysql to bind on my ip address in my.cnf:
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.
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:
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';