sql server database PHP remote connection to the MYSQL database is very slow solution

I don’t know how to solve it, so I installed MYSQL on the server where his space is located to solve the problem. Today I have this problem again. I can’t install MYSQL on this server too. Search:
PHP remote connection to MYSQL is slow, Sometimes the remote connection to MYSQL takes 4-20 seconds, but the local connection to MYSQL is normal. The main reason for this problem is that the default installed MYSQL has reverse DNS resolution enabled. In my.ini (under WINDOWS system) or MY Add the sentence skip-name-resolve under [mysqld] in the .CNF (under UNIX or LINUX system) file and save it.
Start--》Run--》cmd--》net stop mysql--》net start mysql--》Haha, success
The path where my.ini is located is such as: D:Program FilesMySQLMySQL Server 5.0my.ini
It turns out to be MySQL The problem is, after doing this, you can no longer use the host name in the MySQL authorization table, but only the ip.

The above introduces the solution to the very slow PHP remote connection to the MYSQL database of the sql server database, including the content of the sql server database. I hope it will be helpful to friends who are interested in PHP tutorials.