mysql设置权限

#添加用户
create user ‘xcf’@'%'identified by ‘root’;

#删除用户
drop user xcf;

#为用户授权所有数据库的增删改查操作
grant select,insert,update,delete on . to xcf@‘%’;

#刷新权限
FLUSH PRIVILEGES;

#给用户新增某个表的增删改查权限
grant select, insert, update, delete,create on my_test.tb_user to xcf@‘%’;
FLUSH PRIVILEGES;

#给用户设定某个数据库中的所有表的权限
grant select, insert, update, delete,create on my_test.* to xcf@‘%’;
FLUSH PRIVILEGES;

#create权限
grant create on . to xcf@‘%’ ;
FLUSH PRIVILEGES;

#修改表权限
grant alter on . to xcf@‘%’ ;
FLUSH PRIVILEGES;

#删除表权限
grant drop on . to xcf@‘%’ ;
FLUSH PRIVILEGES;

#对用户赋予所有数据库的所有权限
grant all on . to xcf;
FLUSH PRIVILEGES;

#刷新数据库
grant reload on . to xcf;
FLUSH PRIVILEGES;

#给用户设定mysql数据库下所有表的所有权限
grant all on mysql.* to xcf;
FLUSH PRIVILEGES;

#给用户撤销mysql数据库下所有表的所有权限
revoke all on mysql.* from xcf;
FLUSH PRIVILEGES;

#撤销create权限
revoke create on . from xcf@‘%’;
FLUSH PRIVILEGES;

查看权限
show grants for xcf;