MySQL对数据库用户的操作

注：@‘%’：表示允许远程连接，@‘localhost’ ：限制本地登陆

– 根据用户名、权限查询用户
SELECT USER FROM mysql.user WHERE USER=‘your_name’ AND HOST=‘%’;
– 彻底删除用户
DROP USER ‘appuser’@‘%’;
– 刷新使其生效
FLUSH PRIVILEGES;

– 查询数据库所有用户
SELECT * FROM mysql.user

– 创建数据库新用户，设置新密码
CREATE USER ‘your_name’@‘%’ IDENTIFIED BY ‘your_pass’;
– 授予用户数据库权限
GRANT SELECT, INSERT, UPDATE, DELETE, DROP,LOCK TABLES ON your_database.* TO ‘your_name’@‘%’;
– 刷新权限使其生效
FLUSH PRIVILEGES;

– 5.6版本修改root用户权限
SET PASSWORD FOR ‘your_username’@‘localhost’ = PASSWORD(‘your_pass’)
– 刷新权限使其生效
FLUSH PRIVILEGES;