mysql中DCL常用的用户和权限控制

create user '用户名'@'主机名' identified by '密码';

alter user '用户名'@'主机名' identified with mysql_native_passWord by '密码';

drop user '用户名'@'主机名';

#1 查询用户
use mysql;
select * from user;
#2 创建用户
create user 'root'@'localhost' identified by '123456';
#3 修改用户密码
alter user 'root'@'localhost' identified with mysql_native_password by '1234';
#4 删除用户
drop user 'root'@'localhost';

show grants for '用户名'@'主机号';

grant 权限列表 on 数据库名.表名 to '用户名'@'主机号';

revoke 权限列表 on 数据库名.表名 from '用户名'@'主机号';

# 查询权限
show grants for 'root'@'localhost';
# 授予权限
grant all on test.* to 'root'@'localhost';
# 删除权限
revoke all on test.* from 'root'@'localhost';