mysql 用户创建、授权及删除、取消权限操作

2019独角兽企业重金招聘Python工程师标准>>>

删除、取消权限操作：

1. drop user 'user_name'@'%';

2. drop user 'user_name'@'localhost'

3. flush privileges; //重新加载授权表

注意：delete from user where user='user_name'；直接操作mysql.user表不行，重建同名用户时会出现“operation CREATE USER failed”错误提示信息

 

添加用户、授权操作

1. create USER ’user_name' identified by 'password'; //创建用户名和密码

2. grant ALL ON 'db_name'.'tb_name' TO 'user_name'@'%' identified by 'password' //给 ‘user_name’@'%'授权

3. grant ALL ON 'db_name'.'tb_name' TO 'user_name'@'localhost' identified by 'password' //给 'user_name'@'localhost'授权

4. flush privileges; //重新加载授权表

转载于:https://my.oschina.net/u/1251536/blog/709111