ERROR 1130: an effective solution to mysql 1130 connection errors

ERROR 1130: an effective solution for mysql 1130 connection errors today sqlyog is used to connect to the database of a non-local Mysql server. It is strange that the connection fails. ERROR 1130 is reported. ERROR 1130: host 192.168.3.100 is not allowed to connect to this MySQL server. It is assumed that the remote connection User Permissions cannot be obtained. As a result, the mysql database can be operated. Special post .. After logging on to mysql on the local machine, change the "host" item in the "user" table in the "mysql" database, and rename it '%' from "localhost '.. Www.2cto.com mysql-u root-pmysql> use mysql; mysql> select 'host' from user where user = 'root '; mysql> update user set host = '%' where user = 'root'; mysql> flush privileges; mysql> select 'host' from user where user = 'root '; the first sentence is to authorize the user root to log on to the second sentence: select the mysql database third sentence: view the host value of the user table in the mysql database (the host/IP name that can be accessed through connection) fourth sentence: modify the host value (adding host/IP addresses with the wildcard % content). Of course, you can also directly add IP addresses. The fifth sentence is to refresh the MySQL system permission table. The sixth sentence is: when you re-view the user table, there are modifications .. Remember that the Mysql service needs to be restarted (make sure the modification is valid). Otherwise, the modification results may not be reflected.