mysql-Rights Management

Query Users:Select User  from User; Authorization permission: Grant the specified permission:Grant Insert,Select  on *.*  to 'user_name'@'localhost'  with Grant option; (*.*For example: A.B=Table B in database a grants all permissions:Grant  All Privileges  on *.*  to 'user_name'@'localhost'  with Grant option; View permissions: Show Grants for 'user_name'@'localhost';    To view the permissions of the current User: show grants; Reclaim permissions: Reclaim specified permissions:Revoke Insert,Select,Grant option  on *.*  from 'user_name'@'localhost' ...; Reclaim All permissions:Revoke  All Privileges,Grant option  from 'User'@'localhost' ...; Grant Insert,Select  on *.*  to 'Zhangsan'@'localhost'  with Grant option; Show Grants for 'Zhangsan'@'localhost';

mysql-Rights Management