1130 error resolution when connecting to MySQL

deployed a database using MySQL program, SQLYOG connection to non-local MySQL server database, incredibly unable to connect very strange, reported one 30 errors,
ERROR 1130:host 192.168.3.100 isn't allowed to connect to this MySQL server

Conjecture is a problem with user permissions that cannot be given to remote connections. As a result, the MySQL library can be solved. Special stickers come out. After you log in to MySQL, change the "host" entry in the "User" table in the "MySQL" Database, and rename "%" 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 log in as the 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

Clause five: Refresh MySQL system permissions related table

The sixth sentence: when you re-view the user table, there are modifications.

Remember that the MySQL service needs to be restarted (make sure the changes are valid), otherwise the result of the modification may not be reflected.

It is important to note that:

1. The above commands need to be executed under the cmd command.

2. You need to switch to the deployed directory to execute these commands. CD X:\dir

The 3.MYSQL commands are all ";" End of.

4. When executing the first command, you need to manually enter the password that you need to do not copy the password that is required by the deployment program.

1130 error resolution when connecting to MySQL