mysql 权限管理
---恢复内容开始---
grant all privileges on database.table to 'user'@'ip' identified by 'passwd' with grant option;
grant select,insert on mt.* to 'mtp'@'192.168.25.20' identified by 'meal123456' with grant option;
删除权限
revoke drop on mt.* from 'mtp'@'192.168.25.20';
查权限
show grants for mtp@'192.168.25.20';
---恢复内容结束---
grant all privileges on database.table to 'user'@'ip' identified by 'passwd' with grant option;
grant select,insert on mt.* to 'mtp'@'192.168.25.20' identified by 'meal123456' with grant option;
删除权限
revoke drop on mt.* from 'mtp'@'192.168.25.20';
查权限
show grants for mtp@'192.168.25.20';
查看mysql数据库中所有用户
mysql> SELECT DISTINCT CONCAT('''',user,'''@''',host,''';') AS query FROM mysql.user;
查看数据库中具体某个用户的权限
mysql> show grants for 'cactiuser'@'%';