CREATE USER ‘用户名’@数据库地址 IDENTIFIED BY '密码';
例如:CREATE USER ‘test’@localhost IDENTIFIED BY ‘123456’;
给用户授权
GRANT 权限1,..., 权限n ON 数据库.* TO ‘用户名’@数据库地址;
例如:
GRANT CREATE,ALTER,DROP,INSERT,UPDATE,DELETE,SELECT ON test.* TO 'test'@localhost
GRANT ALL ON test1.* TO test2@localhost
撤销授权
REVOKE 权限1, … , 权限n ON 数据库.* FROM ‘用户名’@数据库地址
例如:
REVOKE CREATE,ALTER,DROP ON test1.* FROM 'test'@localhost;
查看用户权限
SHOW GRANTS FOR ‘用户名’@数据库地址
例如:
SHOW GRANTS FOR 'test'@localhost;
删除用户
DROP USER ‘用户名’@数据库地址
例如:
DROP USER ‘test’@localhost;
修改用户密码(以root身份)
use mysql;
alter user '用户名'@localhost identified by '新密码';