在服务器上查看mysql数据库的用户和对应的权限

一、登录数据库(通过Xshell)

# mysql -uroot -p

二、查看数据库

mysql> show databases;

三、查看MYSQL数据库中所有用户

mysql> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
+---------------------------------------+
| query                                 |
+---------------------------------------+
| User: 'cactiuser'@'%';                | 
| User: 'common_user'@'%';              | 
| User: 'dba'@'%';                      | 
| User: 'root'@'%';                     | 
| User: 'slave'@'%';                    | 
| User: 'wtgame'@'%';                   | 
| User: 'root'@'127.0.0.1';             | 
| User: 'webman'@'127.0.0.1';           | 
| User: 'root'@'192.168.166.200&