MySQL settings allow extranet access (graphics)
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 a "%" this host value, then skip this step)
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
(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.1.100) to connect to the MySQL server with user tuser and password tpwd
Mysql> GRANT All privileges on * * to ' tuser ' @ ' 192.168.1.100 ' identified by ' tpwd ' with GRANT OPTION;
mysql> flush Privileges;
MySQL settings allow extranet access (graphics)