MySQL Rights Management

1. Create a user

CREATE USER 'Dingyingsi'@'localhost'Identified by 'dys123';//Create the user on this computerCREATE USER 'Dingyingsi'@'%'Identified by 'dys123'; The user created can connect to the computer remotely

2. Authorization

Grant Select,Insert,Update,Delete,Create,Drop  onDys.tb1 to 'Dingyingsi'@'localhost'Identified by 'dys123';Grant  All Privileges  onDys.tb1 to 'Dingyingsi'@'localhost'Identified by 'dys123';
Grant All Privileges  on *.*  to 'Dingyingsi'@'localhost'Identified by 'dys123';

3. Revoke Permissions

Revoke  All Privileges  on *. *  from [Email protected] "%";   Revoke  All  on  from [Email protected] "%";   Revoke  All  on DB1. *  from [Email protected] "%";  

MySQL Rights Management