• DCL：管理用户，授权

用户管理操作

— 查询用户 use mysql; SELECT * from user;

— 添加用户

CREATE USER ‘zhangsan’@’localhost’ IDENTIFIED BY ‘123’

CREATE USER ‘lisi’@’%’ IDENTIFIED BY ‘123’

— 删除用户

DROP USER ‘zhangsan’@’localhost’

— 修改密码

set password for ‘lisi’@’%’ = password(‘1234’);

— 修改root密码

— 第一步,停止mysql服务

— 第二步,新建窗口A：mysqld —skip-grant-tables

— 第三步,新建窗口B：直接mysql就可以登录

用户权限管理

— 查询权限

— GRANT USAGE ON . TO ‘lisi’@’%’

SHOW GRANTS FOR ‘lisi’@’%’;

— GRANT ALL PRIVILEGES ON . TO ‘root’@’localhost’ WITH GRANT OPTION

SHOW GRANTS FOR ‘root’@’localhost’;

— 授予权限

GRANT SELECT,DELETE,UPDATE ON test.emp to ‘lisi’@’%’;

— 所有权限 所有表

GRANT ALL ON . to ‘lisi’@’%’;

— 解除授权

REVOKE ALL ON . FROM ‘lisi’@’%’;