TABLE NAMEmysql_db_users
DESCRIPTIONThe mysql_db_users table stores which mysql_server_users can access
which mysql_databases . The user permissions are also contained in each row. COLUMNScolumn | type | null | unique | references | referenced_by | since_version | description |
---|
pkey | pkey | false | true | | | 1.0a100 | a generated primary key | mysql_database | fkey | false | false | mysql_databases.pkey | | 1.0a100 | the pkey in mysql_databases | mysql_server_user | fkey | false | false | mysql_server_users.pkey | | 1.31 | the pkey in mysql_server_users | select_priv | boolean | false | false | | | 1.0a100 | the SELECT privilege | insert_priv | boolean | false | false | | | 1.0a100 | the INSERT privilege | update_priv | boolean | false | false | | | 1.0a100 | the UPDATE privilege | delete_priv | boolean | false | false | | | 1.0a100 | the DELETE privilege | create_priv | boolean | false | false | | | 1.0a100 | the CREATE privilege | drop_priv | boolean | false | false | | | 1.0a100 | the DROP privilege | grant_priv | boolean | false | false | | | 1.0a100 | the GRANT privilege | references_priv | boolean | false | false | | | 1.0a100 | the REFERENCES privilege | index_priv | boolean | false | false | | | 1.0a100 | the INDEX privilege | alter_priv | boolean | false | false | | | 1.0a100 | the ALTER privilete | create_tmp_table_priv | boolean | false | false | | | 1.0a111 | the Create_tmp_table_priv | lock_tables_priv | boolean | false | false | | | 1.0a111 | the Lock_tables_priv | create_view_priv | boolean | false | false | | | 1.4 | the Create_view_priv | show_view_priv | boolean | false | false | | | 1.4 | the Show_view_priv | create_routine_priv | boolean | false | false | | | 1.4 | the Create_routine_priv | alter_routine_priv | boolean | false | false | | | 1.4 | the Alter_routine_priv | execute_priv | boolean | false | false | | | 1.4 | the Execute_priv | event_priv | boolean | false | false | | | 1.54 | the Event_priv | trigger_priv | boolean | false | false | | | 1.54 | the Trigger_priv |
|