MySQL adds skip-name-resolve cannot link the database problem solution _mysql

MySQL adds skip-name-resolve can't link the problem,

To verify that MYSQL is authorized by the host name

In the MYSQL Server configuration file My.ini, add the following two lines:

[Mysqld]
Skip-name-resolve

It will prevent MySQL Server from DNS resolution of external connections, and this option eliminates the time that MySQL can perform DNS resolution.
Note, however, that if this option is turned on, all remote host connection authorizations will be in the IP address mode, otherwise MySQL won't be able to handle the connection request properly.
If the Skip-name-resolve option is turned on, verify that MYSQL is authorized by the host name.

Run the following command in MySQL:

Mysql> Select User,host from Mysql.user where host <> ' localhost ';

A record of "%" authorization (i.e. any address) is generally obtained:

No record does not meet the conditions, you need to modify the localhost to replace the 127.0.0.1

MySQL added skip-name-resolve can not link the problem, modified to restart MySQL on the

If there is a host name "DB1" "DB2", delete the Hostanme record in the authorization table and restart the mysqld.