How to remotely connect to a local MySql database

First: Change the "host" item in the "user" table in the "mysql" database from "localhost" to '%'.
Or add a new record, the "host" item is the IP address to be accessed, and authorize it. Restart the mysql service.
Second: Add exception port: 3306 to the system firewall and allow exceptions.

Error message:
ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server
Solution:
1. Change the table method. It may be that your account does not allow remote login, only localhost. At this time, as long as you log in to mysql on the computer at localhost, change the "host" item in the "user" table in the "mysql" database from "localhost" to "%"
1.mysql -u root - pvmware
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;

2. Authorization Law. For example, you want myuser to connect to the mysql server from any host using mypassword.

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
If you want to allow user myuser to connect to mysql from the host with ip 192.168.1.3 server, and use mypassword as the password
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

3. In the firewall that comes with the window Add the exception in port 3306

Summary:
mysql -u root -p
mysql>use mysql;
mysql>select 'host' from user where user='root';
mysql>update user set host = '%' where user ='root';
mysql>flush privileges;
mysql>select 'host' from user where user='root';
First The second sentence is to log in with the authorized user root
The second sentence: Select the mysql library
The third sentence: Check the host value of the user table in the mysql library (that is, the host/IP name for connection access)
The first sentence Fourth sentence: Modify the host value (add the host/IP address with wildcard % content), of course you can also directly add the IP address
Fifth sentence: Refresh the MySQL system permissions related table
Sixth sentence: Check again The user table has been modified. .

Restart the mysql service to complete.

Restart mysql command: net stop mysql

net start mysql

For more related articles on how to remotely connect to the local MySql database, please pay attention to the PHP Chinese website!