MySQL Set external IP access

1, modify the table, log in to the MySQL database, switch to the MySQL database, using SQL statements to view
"Select Host,user from User;"
\mysql-u root-pvmwaremysql>use MySQL;
\mysql>update User Set host = '% ' where user = ' root ';
\mysql>select host, user from user;
\mysql>flush privileges;

Note: The last sentence is important in order for the changes to take effect. If you do not write, you still cannot connect remotely.

2, authorized users, you want to root with a password from any host to connect to the MySQL server
\grant all privileges on * * to ' root ' @ '% ' identified by ' admin123 ' with GRANT option;flush privileges;

If you want to allow user root to connect to a MySQL server from a host with IP 192.168.12.16
\grant all privileges on * * to ' root ' @ ' 192.168.1.16 ' identified by ' 123456 ' with GRANT OPTION;

MySQL Set external IP access