MySQL authorized users to access work notes remotely

Log on to the MySQL server with root

Mysql-h Localhost-u Root

Give any host the use of username remote access

Mysql>grant all privileges in *.* to ' username ' @ '% ' with GRANT OPTION

Setting the specified user can only access from the specified IP, this is the user who created the remote access

Grant all privileges on *.* to ' user ' @ ' 192.168.1.250 ' identified by ' password ' with GRANT OPTION;

Specifies that an existing user can access only the specified IP

Grant all privileges in *.* to ' user ' @ ' 192.168.1.250 ' with Grant OPTION;

Refresh Effective

FLUSH Privileges