MySQL Permissions section

Usage changes the existing account resources without affecting the permissions of the account:

GRANT USAGE on *.*to ' Test ' @ '% ' with max_queries_pre_hour 10000//within one hours the number of queries can not exceed 10,000 times max_connections_pre_hour 100; No more than 100 connection times in one hours

Rename change the name of the original account or the host, you can not modify the permissions of any user

RENAME USER ' Test ' @ '% ' to ' daneil ' @ ' localhost '; Modify its user name and host

Rest recharge environment and log files for some servers

Revoke remove a permission

REVOKE SELECT On * */Remove the query permission from the test account from ' Test ' @ '% ';

Set passwd setting user password

SET PASSWORD for ' test ' @ ' localhost ' = PASSWORD (' his_passwd '); Set a password for a test

SHOW grants a given user lists the specified grant statement

SHOW GRANTS for ' test ' @ ' localhost '; Displays the specified GRANT statement

Show privileges Display all system permissions List

　　

MySQL Permissions section