13. User and rights management

One ： Create users and grant permissions

grant select,update 
on test.emp 
to tom@localhost identified 
by '123';

Two ： View permissions

1. Check your own permissions

show grants;

2. View other people's permissions

show grants for  user name @ Source address ;

3、 ... and ： Revoke authority

1. Revoke authority

revoke delete 
on shop.user 
from mike@'%';

Four ： Delete user

use mysql;
delete from user where user=' user name ';
flush privileges;