#创建用户
CREATE USER user_01 IDENTIFIED WITH PLAINTEXT_PASSWORD BY '123'
#授权 *.* 前面是数据库 后面表名
GRANT ALL ON *.* TO john;
#取消授权
REVOKE SELECT ON customtablename.* FROM john;
查看授权情况
SHOW GRANTS FOR lkt
查看用户
show users
#创建用户
CREATE USER user_01 IDENTIFIED WITH PLAINTEXT_PASSWORD BY '123'
#授权 *.* 前面是数据库 后面表名
GRANT ALL ON *.* TO john;
#取消授权
REVOKE SELECT ON customtablename.* FROM john;
查看授权情况
SHOW GRANTS FOR lkt
查看用户
show users