#查询数据库所有用户 SELECT USER,host FROM mysql.user #新建数据库用户 create user ‘tianxftest1‘@‘%‘ IDENTIFIED by ‘456123‘ #赋予用户角色 revoke all PRIVILEGES on ‘pmp_user‘.* FROM ‘tianxftest1‘@‘%‘ IDENTIFIED by ‘456123‘ #删除用户如下 drop user tianxftest1@192.168.222.110 ; drop user [email protected]‘%‘; #查看用户权限 show grants for tianxftest1; #授权用户拥有数据库的所有权限 grant all privileges on fe.* to fe_group@localhost identified by ‘123456 #刷新权限表 flush privileges #作用到某个数据库的具体某张表 grant select, insert, update, delete on testdb.orders to [email protected]; #作用到某张表的具体列上 grant select(id, se, rank) on testdb.apache_log to [email protected]; #撤销某个用户的某个权限 revoke all on *.* from [email protected];