Troubleshoot remote connections MySQL error 1130
Remotely connect to MySQL server's database, error code is 1130,error 1130:host xxx.xxx.xxx.xxx are not allowed to connect to this MySQL server
Conjecture is a problem with user permissions that cannot be given to remote connections.
In this way, the MySQL library can be resolved.
After you log in to MySQL, change the "host" entry in the "User" table in the "MySQL" Database, and rename it from "localhost" to "%".
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 in as user root with permissions
Second sentence: select MySQL Library
The third sentence: View the host value of the user table in the MySQL library (hosts/IP names that can be accessed by the connection)
Clause Four: Modify the host value (increase the hostname/IP address with the wildcard%), or you can directly add
If this step goes Wrong "error 1062 (23000): Duplicate entry '%-root ' for key ' PRIMARY '" by stating that the record has, skip this step
Clause five: Refresh MySQL system permissions related table
The sixth sentence: when you re-view the user table, there are modifications.
Restart the MySQL service to complete.
Troubleshoot remote connections MySQL error 1130 (reprint)