IP address cocould not be resolved: Temporary failure in name resolution, resolvedresolution

IP address cocould not be resolved: Temporary failure in name resolution, resolvedresolution

Mysql logs were found to have the following warnings this morning:

140724 18:41:25 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary failure in name resolution
140724 18:41:25 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary failure in name resolution
140724 18:41:26 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary failure in name resolution
140724 18:41:26 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary failure in name resolution
140724 18:41:27 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary failure in name resolution
140724 18:41:28 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary failure in name resolution
140724 18:41:28 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary failure in name resolution
140724 18:41:28 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary failure in name resolution
140724 18:41:28 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary failure in name resolution
140724 18:44:54 [Warning] IP address '61. 143.209.110 'cocould not be resolved: Temporary failure in name resolution
140724 18:44:54 [Warning] IP address '61. 143.209.110 'cocould not be resolved: Temporary failure in name resolution
140724 18:44:54 [Warning] IP address '61. 143.209.110 'cocould not be resolved: Temporary failure in name resolution
140724 18:44:54 [Warning] IP address '61. 143.209.110 'cocould not be resolved: Temporary failure in name resolution
140724 18:44:54 [Warning] IP address '61. 143.209.110 'cocould not be resolved: Temporary failure in name resolution
140724 18:44:55 [Warning] IP address '61. 143.209.110 'cocould not be resolved: Temporary failure in name resolution
140724 18:44:55 [Warning] IP address '61. 143.209.110 'cocould not be resolved: Temporary failure in name resolution
140724 18:44:55 [Warning] IP address '61. 143.209.110 'cocould not be resolved: Temporary failure in name resolution
140724 18:44:55 [Warning] IP address '61. 143.209.110 'cocould not be resolved: Temporary failure in name resolution

Cause:
The cause of the error is that the MYSQL Server maintains a non-local Client TCP cache in the local memory, which contains the logon information of the remote Client, such as the IP address and hostname.
After the Client connects to the server, Mysql first resolves the Client's hostname or reverse resolution based on the IP address in the local TCP pool. If the resolution fails, it will go to the DNS for resolution. If the resolution still fails
This is to write such warning information in the error log.

Solution:
1. You can use two parameters to disable this function. In the MYSQL configuration file [mysqld], add the following parameters:
[Mysqld]
-- Skip-host-cache
-- Skip-name-resolve

Re-authorize, and change all the authorization methods for accessing the database server to IP.
Grant all on *. * to 'root' @ '192. 16.12.68 'identified by '123 ';

2. Add authorization.
Change the authorization method for accessing the database server to IP address.
Different users use different user names and passwords.
Grant all on *. * to 'user _ 68 '@ '192. 16.12.68 'identified by 'pwd _ 68 ';
Grant all on *. * to 'user _ 67' @ '192. 16.12.67 'identified by 'pwd _ 67 ';
....
Delete the permission records containing the host name in the user table and db table under the mysql database.

Summary:

1. Either add
-- Skip-host-cache
-- Skip-name-resolve

So that MySQL will no longer use DNS resolution addresses.

2. You can use the IP address directly when granting permissions to remove those permissions with the host name.

Localhost: ssh: localhost: Temporary failure in name resolution !!!!

The prompt is that you have no name resolution, you need to configure the dns server address (the dns server must have corresponding entries), or you can use the IP address to directly connect.

The server name or address cocould not be resolved window is always displayed on The computer, and The wireless network cannot be connected.

Run cmd and run ipconfig/renew to fix the network connection.