1, users connect to MySQL, and make a variety of inquiries, the user right you are the limit of the check
1, for MySQL you have no permission to connect up, must meet the following three parameters:
1. Where do you come from? : Host
2. Who are you? : User
1, add a User:
Command format: Grant [Permissions 1, Permissions 2, Permissions 3] on * * to [email protected] identified by password
2. View the permissions of a user:
SELECT * from user where user=root \g;
3, Recovery rights:
Revoke [Permissions] on * * FROM [email protected];
4. Permission level:
User (global), DB (Library), table (level)
View Hierarchy Permissions: SELECT * Form User/db/table_priv \g;
3. Your password? : Password
1, change the password:
1. Update user Set Password = password (' 111111 ') where user = root;
Flush privileges;
4. These three messages are stored in the user table in the MySQL database
5, UPDATE permissions: Flush privileges;
2. Do you have permission to perform this operation
: SELECT * from user where user = ' user_name ' \g;