Overview
mysql.db provides information about system-level privileges.
Related tables/views
None
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| host | varchar(128) | NO | The host name. |
| db | varchar(128) | NO | The name of the database. |
| user | varchar(128) | NO | The username. |
| select_priv | varchar(1) | NO | Indicates whether the user can execute the SELECT statement. |
| insert_priv | varchar(1) | NO | Indicates whether the user can execute the INSERT statement. |
| update_priv | varchar(1) | NO | Indicates whether the user can execute the UPDATE statement. |
| delete_priv | varchar(1) | NO | Indicates whether the user can execute the DELETE statement. |
| create_priv | varchar(1) | NO | Indicates whether the user can execute the CREATE statement. |
| drop_priv | varchar(1) | NO | Indicates whether the user can execute the DROP statement. |
| grant_priv | varchar(1) | NO | Indicates whether the user can grant privileges. |
| reference_priv | varchar(1) | NO | This field has not been used. |
| index_priv | varchar(1) | NO | Indicates whether the user can create indexes. |
| alter_priv | varchar(1) | NO | Indicates whether the user can execute the ALTER TABLE statement. |
| create_tmp_table_priv | varchar(1) | NO | Indicates whether the user can create temporary tables. This field has not been used. |
| lock_tables_priv | varchar(1) | NO | Indicates whether the user can execute the LOCK TABLES statement. To execute this statement, the user must have the SELECT privilege on the table. This field has not been used. |
| create_view_priv | varchar(1) | NO | Indicates whether the user can execute the CREATE VIEW statement. |
| show_view_priv | varchar(1) | NO | Indicates whether the user can execute the SHOW CREATE VIEW statement. |
| create_routine_priv | varchar(1) | NO | Indicates whether the user can create stored procedures. This field has not been used. |
| alter_routine_priv | varchar(1) | NO | Indicates whether the user can execute the ALTER FUNCTION statement. This field has not been used. |
| execute_priv | varchar(1) | NO | Indicates whether the user can execute stored procedures. This field has not been used. |
| event_priv | varchar(1) | NO | Indicates whether the user can create, delete, or modify events. This field has not been used. |
| trigger_priv | varchar(1) | NO | Indicates whether the user can execute the CREATE TRIGGER or DROP TRIGGER statement. This field has not been used. |