1 创建用户
CREATE USER 用户名@地址 IDENTIFIED BY '密码';
CREATE USER [email protected] IDENTIFIED BY ‘’;
CREATE USER user2@’%’ IDENTIFIED BY ‘’;
2 给用户授权
GRANT 权限, … , 权限n ON 数据库.* TO 用户名@IP
GRANT CREATE,ALTER,DROP,INSERT,UPDATE,DELETE,SELECT ON mydb1.* TO [email protected];
GRANT ALL ON mydb1.* TO user2@’%’;
3 撤销授权
REVOKE权限1, … , 权限n ON 数据库.* FORM 用户名
REVOKE CREATE,ALTER,DROP ON mydb1.* FROM [email protected];
4 查看用户权限
SHOW GRANTS FOR [email protected];```
5 删除用DROP USER 用户名
DROP USER [email protected];
6 修改用户密码
Use mysql;
UPDATE USER SET PASSWORD=PASSWORD(‘密码’) WHERE User=’用户名’;
FLUSH PRIVILEGES;
UPDATE USER SET PASSWORD=PASSWORD('1234') WHERE User='user2';
FLUSH PRIVILEGES;