Mysql remote connection error 1130

Mysql
Remotely connect to the Mysql server database. The ERROR code is 1130, ERROR 1130: Host xxx. xxx is not allowed to connect to this MySQL server
It is assumed that the remote connection User Permissions cannot be granted.
In this way, you can operate the mysql database.
 
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 ';
 
 
 
First sentence: Log On with the root user of the permission
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 ..
Restart the mysql service.



By fireDragonpzy