MySql常用Sql语句

//查看所有用户
SELECT user,host FROM mysql.user;

//添加用户
CREATE USER 'root'@'%' IDENTIFIED BY '';

//删除用户
DROP USER ''@'';

//更改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '';
SET password FOR ''@'' = password(''); 

//授予全部权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

//授予全部权限，并且可传递
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

//收回权限
REVOKE ALL ON *.* FROM 'root'@'%'; 

//收回传递权限
REVOKE GRANT OPTION ON *.* FROM 'root'@'%'; 

//刷新权限
FLUSH PRIVILEGES;