Shulou(Shulou.com)06/01 Report--

First check the mysql error log:

Cd / usr/local/mysql/var/ tail VM_79_224_centos.err

The name of the log may be different, depending on the actual situation

Open and see an error similar to the following:

110617 14:04:10 [Warning] IP address' 19.200.90.16' could not be resolved: Temporary failure in name resolution110617 14:07:48 [Warning] IP address' 19.200.57.44' could not be resolved: Temporary failure in name resolution

This error log indicates that mysql performs dns resolution on ip addresses. The solution is to modify the my.cnf configuration file to cancel dns resolution.

Do the following:

Vi / etc/my.cnf

Add a line to the my.cnf:

Skip-name-resolve

Save, exit, restart mysql service, ok

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.