ERROR 1130: effective solution for mysql 1130 connection errors

When sqlyog is used to connect to a database of a non-local Mysql server, it is strange that the database cannot be connected. The 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 granted. 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 '..

Mysql-u root-p

Mysql> 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.

Second sentence: Select 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 (add host/IP address with the wildcard % content), of course, you can also directly add IP addresses

Fifth sentence: refresh the MySQL system permission table

The sixth statement is modified when you re-view the user table ..

Remember that the Mysql service needs to be restarted (make sure the modification is valid). Otherwise, the modification results may not be reflected.