The program is under Windows 8.1 64 bit, and the MySQL server is located under CentOS 6.5 64, and the problem of the connection speed is too slow!
In order to make the test environment of the intranet as much as possible to the online production environment, the httpd, ftp, mysql, etc. of the intranet are all installed on the CentOS 6.5 64 bit, but my development environment is still Windows 8.1 64-bit, and the program is also in the development environment, so the problem of connecting to MySQL is too slow. If you connect to this machine, it is very fast.
The solution is as follows:
Running in phpMyAdmin: Show ProcessList
![在mysql配置文件my.cnf中f的[mysqld]一节中增加skip-name-resolve。](https://www.shuijingwanwq.com/wp-content/uploads/2014/12/22.png)
in mysql configuration file my.cnf[mysqld]Add skip-name-resolve in one section.
