Mysql allows extranet access setup steps _mysql

1, open Mysql.exe (MySQL Command line Client), enter the password

2, input: use MySQL;

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

4, create the host (if there is "%" the host value, then skip this step)

If there is no "%" host value, execute the following two sentences:

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

5, authorized users

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

Mysql> grant all privileges in *.* to ' root ' @ '% ' identified by ' pwd ' with GRANT OPTION;
mysql> flush Privileges;

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

Mysql> grant all privileges in *.* to ' tuser ' @ ' 192.168.1.100 ' identified by ' tpwd ' with GRANT OPTION; 
mysql> flush Privileges;

The above mentioned is a small set of MySQL to introduce you to allow access to the Internet settings steps, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!