How to set up to allow extranet access to MySQL

1. Change the host data of the first record of the user table in the local database to%, or use the update user set host= '% ' where user= ' root ';

2, the command line client with MySQL operation the following steps: First to enter a password, usually 123456, and then

Any host connected to the MySQL server with user root and password 123456
Mysql> GRANT All privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT OPTION;
mysql> flush Privileges;

Hosts with IP 192.168.1.102 connect to MySQL server with user myuser and password mypwd
Mysql> GRANT All privileges on * * to ' myuser ' @ ' 192.168.1.102 ' identified by ' mypwd ' with GRANT OPTION;
mysql> flush Privileges;

3. When connecting a local database with another computer, the connection name should be the local IP address, i.e.:

Guaranteed/Saved connections: 192.168.0.124

My SQL host address: 192.168.0.124

User name: Root

Password: 123456

Port: 3306

How to set up to allow extranet access to MySQL