The mysql.db table stores database-level privileges, determining which users have access to specific databases and what actions they can perform.
The mysql.db table contains information about database-level privileges. The table can be queried and although it is possible to directly update it, it is best to use GRANT for setting privileges.
Note that the MariaDB privileges occur at many levels. A user may not be granted a privilege at the database level, but may still have permission on a table level, for example. See privileges for a more complete view of the MariaDB privilege system.
This table uses the Aria storage engine.
The mysql.db table contains the following fields:
The status variable indicates how many rows the mysql.db table contains.
This page is licensed: CC BY-SA / Gnu FDL
Select_priv
enum('N','Y')
NO
N
Can perform statements.
Insert_priv
enum('N','Y')
NO
N
Can perform statements.
Update_priv
enum('N','Y')
NO
N
Can perform statements.
Delete_priv
enum('N','Y')
NO
N
Can perform statements.
Create_priv
enum('N','Y')
NO
N
Can .
Drop_priv
enum('N','Y')
NO
N
Can or .
Grant_priv
enum('N','Y')
NO
N
User can privileges they possess.
References_priv
enum('N','Y')
NO
N
Unused
Index_priv
enum('N','Y')
NO
N
Can create an index on a table using the statement. Without the INDEX privilege, user can still create indexes when creating a table using the statement if the user has have the CREATE privilege, and user can create indexes using the statement if they have the ALTER privilege.
Alter_priv
enum('N','Y')
NO
N
Can perform statements.
Create_tmp_table_priv
enum('N','Y')
NO
N
Can create temporary tables with the statement.
Lock_tables_priv
enum('N','Y')
NO
N
Acquire explicit locks using the statement; user also needs to have the SELECT privilege on a table in order to lock it.
Create_view_priv
enum('N','Y')
NO
N
Can create a view using the statement.
Show_view_priv
enum('N','Y')
NO
N
Can show the statement to create a view using the statement.
Create_routine_priv
enum('N','Y')
NO
N
Can create stored programs using the and statements.
Alter_routine_priv
enum('N','Y')
NO
N
Can change the characteristics of a stored function using the statement.
Execute_priv
enum('N','Y')
NO
N
Can execute or functions.
Event_priv
enum('N','Y')
NO
N
Create, drop and alter .
Trigger_priv
enum('N','Y')
NO
N
Can execute associated with tables the user updates, execute the and statements.
Delete_history_priv
enum('N','Y')
NO
N
Can delete rows created through .
Host
char(60)
NO
PRI
Host (together with User and Db makes up the unique identifier for this record. Until MariaDB 5.5, if the host field was blank, the corresponding record in the mysql.host table would be examined. From MariaDB 10.0, a blank host field is the same as the % wildcard.
Db
char(64)
NO
PRI
Database (together with User and Host makes up the unique identifier for this record.
User
char(80)
NO
PRI
User (together with Host and Db makes up the unique identifier for this record.