Solution to slow connection on an independent MySQL Server

The MySQL and web servers are separated, and the page is slow to open. There is no such problem at all in the test server. The separation should be faster, but it is slower. I remember this problem. It took a long time and I forgot it. Old, bad memory. Haha.

 

Solution:

[Mysqld]
Skip-name-resolve

Add skip-name-resolve to mysqld and restart MySQL.

This will also cause problems,

Grant all on test. * to DBA @ localhost

The localhost here is a domain name, which cannot be explained. You can only use an IP address..