Remote Connection Mysql Database Note Point record _mysql

First, how to create a new independent account and set permissions

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

Select "User"--"New user"

Enter user name, host, password, it should be noted that the host is not write "localhost", but write "%"

You can then set the server permissions

and specify the permissions for the database, and then save the exit

Second, remote connection slow

Slow is a big problem, the online approach is to My.ini "[mysqld]" Add a line under "skip-name-resolve", like this:

Then save and restart the MySQL service.