Use SELECT statements to see how the user account would be added to the user and db tables : Permission « User Permission « SQL / MySQL






  1. SQL / MySQL
  2. User Permission
  3. Permission

Use SELECT statements to see how the user account would be added to the user and db tables

      


SELECT host, user, select_priv, update_priv FROM user;

SELECT host, db, user, select_priv, update_priv FROM db;








Related examples in the same category

1.Show Permission
2.Use SELECT statements to retrieve data from the user, tables_priv, and columns_priv tables