Two ways to view user permissions in MySQL

Http://yanue.net/post-96.html

Two ways to view the user Rights command in MySQL:

one. Using MySQL grants

For more information on MySQL Grant, see: Http://yanue.net/post-97.html How to use:

  
    
   

   
     
    
Mysql> Show grants for [email protected];
  
    
   

Instance:

  
    
   

   
     
    
Mysql> Show grants for [email protected];

   
     
    
+---------------------------------------------------------------------+

   
     
    
| Grants for [email protected] |

   
     
    
+---------------------------------------------------------------------+

   
     
    
| GRANT all privileges on * * to ' root ' @ ' localhost ' with GRANT OPTION |

   
     
    
+---------------------------------------------------------------------+

   
     
    
1 row in Set (0.01 sec)
  
    
   

two. Directly through the MySQL select query statement:

   
  

    
   

   
Mysql> SELECT * from Mysql.user where user= ' test ' and host= ' 127.0.0.1 ' \g;

    
   

   
1. Row ***************************

    
   

   
host:127.0.0.1

    
   

   
User:test

    
   

   
Password: *eb3c643405d7f53bd4bf7fba98dcf5641e228833

    
   

   
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:n

    
   

   
File_priv:n

    
   

   
Grant_priv:n

    
   

   
References_priv:n

    
   

   
Index_priv:n

    
   

   
Alter_priv:n

    
   

   
Show_db_priv:n

    
   

   
Super_priv:n

    
   

   
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

    
   

   
Create_tablespace_priv:n

    
   

   
Ssl_type:

    
   

   
Ssl_cipher:

    
   

   
X509_issuer:

    
   

   
X509_subject:

    
   

   
max_questions:0

    
   

   
max_updates:0

    
   

   
max_connections:0

    
   

   
max_user_connections:0

    
   

   
Plugin:mysql_native_password

    
   

   
Authentication_string:

    
   

   
Password_expired:n

    
   

   
1 row in Set (0.00 sec)
   
  

Can see Select_priv,insert_priv,update_priv ... Equal to n means no permissions, and the user right is at a glance. Commands can be used at this time

To add permissions to a User:

See http://www.yanue.net/post-97.html

  
    
   

   
     
    
Grant all privileges on * * to ' test ' @ ' 127.0.0.1 ' identified by ' passwd ';

   
     
    
Flush privileges;
  
    
   

In addition: show can see a lot of things:

  
    
   

   
     
    
show databases;

   
     
    
Show tables;

   
     
    
Show CREATE Database dbname; This allows you to see some of the parameters used to create the database.

   
     
    
Show CREATE TABLE tablename; You can see some of the parameters used to create the table
  
    
   

Two ways to view user permissions in MySQL