Slow MySQL remote connection [unsolved]

The local access to MySQL is fast. Several hundred queries are completed in seconds. When the database is set up to an internet server for remote access, the same query will take xx. XX seconds can only be described by turtles.

The following method is generally used to accelerate the speed (Not successful yet)

Configure the mysql. ini file as follows:

[Mysqld]
Skip-name-resolve
Skip-grant-tables

This solves the problem of slow remote access. However, using the skip-grant-tables system, no access control is required for any user's access, and any user name can log on and operate all databases. Is it dangerous?

If you want to allow remote connection and do not allow all permissions, configure it as follows:

The local connection user uses the IP address 127.0.0.1 to connect. the mysql. ini file is configured as follows:

[Mysqld]
Skip-name-resolve