How to set up remote access in MySQL

This is the Windows Server AH. I use the visual interface SQLyog, you can also use Navicat even DOS interface can

After logging in with the root account, write the following code on the query page

GRANT all privileges on * * to MX @ '% ' identified by "123456"; /* Database name. If the table name is written as * * on behalf of all databases */

FLUSH privileges; /* Refresh the content just now */

UPDATE db SET HOST = '% ' WHERE USER = ' mx '; /* (if written as host=localhost that this user does not have remote access) */

FLUSH privileges;

Only these need not be restarted, and then the remote link is made locally via the server's IP and the user name and password you just set.

How to set up remote access in MySQL