mysql用户权限

1 创建数据库

CREATE DATABASE enrd DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

2 创建用户

CREATE USER 'zk3'@'%' IDENTIFIED BY 'Z26';

3 对用户赋予权限
GRANT all privileges ON enterprcord.* TO 'zk3'@'%';

4去掉权限

REVOKE all privileges ON enterpecord.* FROM 'zk3'@'%';

6 删除用户

DROP USER 'z3'@'%';