MySQL Set up extranet connection

1. Open MySQL, enter the password

2, input: use MySQL;

3, query host input: Select User,host from User;

4. Authorized Users

(1) Any host connected to MySQL server with user root and password pwd

Mysql> GRANT All privileges on * * to ' root ' @ '% ' identified by ' pwd ' with GRANT OPTION;

mysql> flush Privileges;

(2) Specify a host with IP (such as 192.168.0.160) to connect to the MySQL server with user tuser and password tpwd

Mysql> GRANT All privileges on * * to ' root ' @ ' 192.168.0.160 ' identified by ' pwd ' with GRANT OPTION;

mysql> flush Privileges;

The first * indicates the name of the second name of the library.

MySQL Set up extranet connection