Mega Code Archive

 

Categories / MySQL / User Permission

 

To view how the user account is added to the grant 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';