Notes for remotely connecting to the mysql database (remote connection to slow skip-name-resolve)

Sometimes we need to remotely connect to the mysql database, so we need to pay attention to the following issues for your convenience. I have prepared some materials for you.

Sometimes we need to remotely connect to the mysql database, so we need to pay attention to the following issues for your convenience. I have prepared some materials for you.

1. How to create an independent account and Set permissions

Here I use Navicat as my database management tool to open Navicat.

Select "user" -- "create user"

Enter the user name, host, and password. Note that the host name is not "localhost", but "%"

Then you can set "server Permissions"

And the permissions of the specified database. Save and exit.

2. Slow remote connection

Slow speed is a big problem. The online method is to add a line under "" Of my. ini, just like this:

Save and restart the mysql service.