mysql> show grants for ‘cactiuser‘@‘%‘;
查看MYSQL数据库中所有用户及拥有权限
标签：cat show span blank from size 权限 get nts
查看MYSQL数据库中所有用户及拥有权限
mysql> SELECT DISTINCT CONCAT(‘User: ‘‘‘,user,‘‘‘@‘‘‘,host,‘‘‘;‘) AS query FROM mysql.user;
查看数据库中具体某个用户的权限
mysql> show grants for ‘cactiuser‘@‘%‘;
mysql> show grants for ‘cactiuser‘@‘%‘;