Mysql settings Specify IP remote Access connection instance _mysql

This example describes the MySQL settings to specify the IP remote Access connection method, share for everyone to reference. The implementation methods are as follows:

1. The authorized user root uses the password jb51 to connect to the MySQL server from any host:

Copy Code code as follows:

Grant all privileges in *.* to ' root ' @ '% ' identified by ' jb51 ' with Grant OPTION;
Flush privileges;

2. The authorized user root uses the password jb51 to connect to the MySQL server from the designated IP-218.12.50.60 host:

Copy Code code as follows:

Grant all privileges in *.* to ' root ' @ ' 218.12.50.60 ' identified by ' jb51 ' with GRANT OPTION;
Flush privileges;

I hope this article is helpful to the design of MySQL database.