Remote connection for MySQL

1. First log on to the remote server, and then log mysql:mysql-u user-p password;
2. Create and empower users that allow remote logins: Grant all privileges the on database. The table name to username @ ' IP address ' identified by password; (All privileges: Indicates that all permissions are given to the specified user, Of course you can also give users specific permissions, such as Select,insert,update,delete,create, specific permissions between the use of ', ' separated Database. Table Name: represents the specific library and the specific table name to be given permissions, you can also give the user all the database and table operation permissions, using *. *, Root: Indicates to which user to grant permissions, the user can be existing, or can not exist; P Address: Indicates the IP address that allows remote connections, use '% ' if IP is not restricted
3. Flush Output buffer: flush privileges;
4. Complete

Remote connection for MySQL