查看MYSQL数据库中所有用户以及单个用户权限

柔光的暖阳◎ 2022-08-06 01:29 253阅读 0赞

查看MYSQL数据库中所有用户

mysql> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;  
\+---------------------------------------+  
| query                                 |  
\+---------------------------------------+  
| User:  ['cactiuser'@'%'][cactiuser] ;                |   
| User:  ['common\_user'@'%'][cactiuser] ;              |   
| User:  ['dba'@'%'][cactiuser] ;                      |   
| User:  ['root'@'%'][cactiuser] ;                     |   
| User:  ['slave'@'%'][cactiuser] ;                    |   
| User:  ['wtgame'@'%'][cactiuser] ;                   |   
| User:  ['root'@'127.0.0.1'][cactiuser] ;             |   
| User:  ['webman'@'127.0.0.1'][cactiuser] ;           |   
| User:  ['root'@'192.168.166.200'][cactiuser] ;       |   
| User:  ['cactiuser'@'192.168.166.202'][cactiuser] ;  |   
| User:  ['root'@'192.168.166.202'][cactiuser] ;       |   
| User:  [''@'localhost'][cactiuser] ;                 |   
| User:  ['cacti'@'localhost'][cactiuser] ;            |   
| User:  ['cactiuser'@'localhost'][cactiuser] ;        |   
| User:  ['dba'@'localhost'][cactiuser] ;              |   
| User:  ['extmail'@'localhost'][cactiuser] ;          |   
| User:  ['javauser'@'localhost'][cactiuser] ;         |   
| User:  ['root'@'localhost'][cactiuser] ;             |   
| User:  ['webman'@'localhost'][cactiuser] ;           |   
| User:  [''@'localhost.localdomain'][cactiuser] ;     |   
| User:  ['root'@'localhost.localdomain'][cactiuser] ; |   
\+---------------------------------------+  
21 rows in set (0.01 sec)

查看数据库中具体某个用户的权限  
mysql> show grants for  ['cactiuser'@'%'][cactiuser] ;      
\+-------------------------------------------------------------------------------------------------------------------+  
| Grants for  [cactiuser@%][cactiuser 1]                                                                                             |  
\+-------------------------------------------------------------------------------------------------------------------+  
| GRANT PROCESS, SUPER ON \*.\* TO  ['cactiuser'@'%'][cactiuser]  IDENTIFIED BY PASSWORD '\*DAFF917B80E3314B1ABECBA9DF8785AFD342CE89' |   
| GRANT ALL PRIVILEGES ON \`cacti\`.\* TO  ['cactiuser'@'%'][cactiuser]                                                               |   
\+-------------------------------------------------------------------------------------------------------------------+  
2 rows in set (0.00 sec)

mysql> select \* from mysql.user where user='cactiuser' \\G     
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
                 Host: %  
                 User: cactiuser  
             Password: \*DAFF917B80E3314B1ABECBA9DF8785AFD342CE89  
          Select\_priv: N  
          Insert\_priv: N  
          Update\_priv: N  
          Delete\_priv: N  
          Create\_priv: N  
            Drop\_priv: N  
          Reload\_priv: N  
        Shutdown\_priv: N  
         Process\_priv: Y  
            File\_priv: N  
           Grant\_priv: N  
      References\_priv: N  
           Index\_priv: N  
           Alter\_priv: N  
         Show\_db\_priv: N  
           Super\_priv: Y  
Create\_tmp\_table\_priv: N  
     Lock\_tables\_priv: N  
         Execute\_priv: N  
      Repl\_slave\_priv: N  
     Repl\_client\_priv: N  
     Create\_view\_priv: N  
       Show\_view\_priv: N  
  Create\_routine\_priv: N  
   Alter\_routine\_priv: N  
     Create\_user\_priv: N  
           Event\_priv: N  
         Trigger\_priv: N  
             ssl\_type:   
           ssl\_cipher:   
          x509\_issuer:   
         x509\_subject:   
        max\_questions: 0  
          max\_updates: 0  
      max\_connections: 0  
 max\_user\_connections: 0

[cactiuser]: mailto:'%20rel=
[cactiuser 1]: mailto:cactiuser@%