查看MYSQL数据库中所有用户及拥有权限

悠悠 2022-01-12 22:39 269阅读 0赞

转自 <[https://www.cnblogs.com/walter371/p/4113196.html&gt][https_www.cnblogs.com_walter371_p_4113196.html_gt];

### 查看MYSQL数据库中所有用户 ###

### 查看数据库中具体某个用户的权限 ###

mysql> show grants for 'cactiuser'@'%';    
    +-------------------------------------------------------------------------------------------------------------------+
    | Grants for cactiuser@%                                                                                            |
    +-------------------------------------------------------------------------------------------------------------------+
    | GRANT PROCESS, SUPER ON *.* TO 'cactiuser'@'%' IDENTIFIED BY PASSWORD '*DAFF917B80E3314B1ABECBA9DF8785AFD342CE89' | 
    | GRANT ALL PRIVILEGES ON `cacti`.* TO '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

查看user表结构　需要具体的项可结合表结构来查询

转载于:https://blog.51cto.com/13770206/2393561

[https_www.cnblogs.com_walter371_p_4113196.html_gt]: https://www.cnblogs.com/walter371/p/4113196.html&gt