User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. Use SELECT statements to retrieve data from the user, tables_priv, and columns_priv tables
SELECT host, user, select_priv, update_priv FROM user WHERE user='user1';
SELECT host, db, user, table_name, table_priv, column_priv
FROM tables_priv WHERE user='user1';
SELECT host, db, user, table_name, column_name, column_priv
FROM columns_priv WHERE user='user1';