Mysql账户管理命令使用说明

Mysql 账户管理

1、创建账户

CREATE USER 'kess'@'localhost' IDENTIFIED BY 'mypass(用户密码)';

2、删除账户（删除账户同时会删除其所有权限）

DROP USER 'kess'@'localhost';

3、分配权限

GRANT ALL ON *.*（*更改授权的数据库名） TO 'kess'@'localhost';
GRANT ALL ON *.* TO 'kess'@'localhost' IDENTIFIED BY 'mypass';（这句命令是创建用户和分配权限一起）

4、回收权限
REVOKE INSERT ON *.* FROM 'kess'@'localhost';
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'kess'@'localhost';
5、查看用户权限
show grants for kess@'localhost';
6、账号更名
RENAME USER 'kess'@'localhost' TO 'test'@'127.0.0.1';
7、修改密码
SET PASSWORD = PASSWORD('mypass');
SET PASSWORD FOR 'kess'@'localhost' = PASSWORD('mypass');
8、查看所有已添加用户信息
select* from mysql.user;
mysql>select host,user,password from mysql.user;  (回车)