Set up MySQL to allow extranet access

1. Modify the configuration file
sudo vim/etc/mysql/my.cnf
Change the value of the bind-address parameter to your internal/external network IP or 0.0.0.0, or comment out the line directly.

2. Log in to the database
Mysql-u root-p

Enter password
mysql> use MySQL;

3. Querying the Host
Mysql> select User,host from user;

4. Create host
If there is no "%" of this host value, the following two sentences are executed:
mysql> Update user set host= '% ' where user= ' root ';
mysql> flush Privileges;

5. Authorized Users
Any host connected to the MySQL server with user root and password mypwd
Mysql> GRANT All privileges on * * to ' root ' @ '% ' identified by ' mypwd ' 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;

PS: The above is the authorization method, the following is the change table method:

mysql> use MySQL;
mysql> Update user set host= '% ' where user= ' root ';
mysql> flush Privileges;

Excerpt from: http://www.cnblogs.com/live41/archive/2013/04/02/2995178.html

Set up MySQL to allow extranet access