Excerpt from: http://www.iteye.com/topic/418151
MySQL Database remote Access Setup method
1. Modify localhost
Change the "host" entry in the "User" table in the "MySQL" database, changing from "localhost" to "%"
Mysql>use MySQL;
Mysql>update User Set host = '% ' where user = ' root ';
Mysql>select host, user from user;
Mysql>flush privileges;
2. Designated authorization
Connect to the MySQL server from any host using Myuser/mypassword:
GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;
Use Myuser/mypassword to connect to the MySQL server from a host with IP 192.168.225.166:
GRANT all privileges on * * to ' myuser ' @ ' 192.168.225.166 ' identified by ' MyPassword ' with GRANT OPTION;
3. Pan-Authorized
Mysql-h Localhost-u Root
Mysql>Grant all privileges on * * to ' root ' @ '% ' with GRANT OPTION; //give any host access to the data as root
Mysql>FLUSH privileges;
troubleshoot problems with MySQL not being able to connect remotely
1, MySQL port is correct
View port occupancy through NETSTAT-NTLP , typically 3306 for the lower end. The use of the tool to connect to MySQL is to use the port. For example, My admin\my Query browser\mysql front and so on.
2. Check whether the user rights are correct
The user table of the MySQL library has two records: host is localhost and% (for security,% can be replaced with IP you need to connect externally).
3. See if the skip-networking has been/etc/mysql/my.cnf
Need to be dropped
Error: Error 2003 (HY000): Can ' t connect to MySQL server on ' 192.168.51.112 ' (111)
sudo gedit/etc/mysql/my.cnf
#skip-external-locking
#bind-address = 127.0.0.1
Skip-name-resolve
4, to see if Iptables is stopped, is not closed, cannot connect
through: Service iptables stop temporarily shut down.
Error: Error 2003 (HY000): Can ' t connect to MySQL server on ' 192.168.51.112 ' (113)