mysqlDCL

一.用户管理

1.查询用户
use mysql;
select * from user;

2.创建用户
create user 'zzz'@'%' identified by '123456';
create user 'zzz'@'localhost' identified by '123456';

3.修改用户密码
alter user 'zzz'@'%' identified by '1234';

4.删除用户
drop user 'zzz'@'%';

二.权限控制

权限类型
select,insert,update,delete,alter,drop,create

1.查询权限
show grants for 'root'@'localhost';

2.授予权限
grant all on mysql.* to 'zzz'@'%';

3.撤销权限
revoke all on mysql.* from root@'localhost';