Grant Tables SHOW GRANTS FOR ’bob’@’pc84.example.com’; To display nonprivilege properties of an account, use  SHOW CREATE USER : SHOW CREATE USER ’bob’@’pc84.example.com’; The server uses the  user  and  db  tables in the  mysql  database at both the first and second stages of access control (see Section 6.2, “Access Control and Account Management” ). The columns in the  user and  db  tables are shown here. The user and db Grant Tables Table 6.4 user and db Table Columns 1207 Table Name user db Scope columns Host Host User Db User Privilege columns Select_priv Select_priv Insert_priv Insert_priv Update_priv Update_priv Delete_priv Delete_priv Index_priv Index_priv Alter_priv Alter_priv Create_priv Create_priv Drop_priv Drop_priv Grant_priv Grant_priv Create_view_priv Create_view_priv Show_view_priv Show_view_priv Create_routine_priv Create_routine_priv Alter_routine_priv Alter_routine_priv Execute_priv Execute_priv Trigger_priv Trigger_priv Event_priv Event_priv Create_tmp_table_priv Create_tmp_table_priv Lock_tables_priv Lock_tables_priv References_priv References_priv Reload_priv Shutdown_priv Process_priv File_priv Show_db_priv Super_priv Repl_slave_priv