Notes for remote connection to mysql database (remote connection to slow skip-name-resolve) _ MySQL

Notes for remote connection to mysql database (remote connection to slow skip-name-resolve) bitsCN.com 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 of "skip-name-resolve" under "[mysqld]" of my. ini, just like this:

Save and restart the mysql service.

BitsCN.com