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; (回车)