W3cubDocs

/MariaDB

The mysql Database Tables

MariaDB comes pre-installed with a system database called mysql containing many important tables storing, in particular, grant and privilege information. Until MariaDB 10.4, system tables used the MyISAM storage engine. From MariaDB 10.4, they use Aria.

Title	Description
mysql.column_stats Table	Column stats for engine-independent statistics
mysql.columns_priv Table	Column-level privileges
mysql.db Table	Database-level access and privileges.
mysql.event Table	Information about MariaDB events
mysql.func Table	User-defined function information
mysql.general_log Table	Contents of the general query log if written to table
mysql.global_priv Table	Global privileges.
mysql.gtid_slave_pos Table	For slaves to keep track of the GTID.
mysql.help_category Table	Help categories
mysql.help_keyword Table	Help keywords
mysql.help_relation Table	HELP command relations
mysql.help_topic Table	Help topics
mysql.host Table	Obsolete/optional table that contained host-level access and privileges.
mysql.index_stats Table	Index stats for engine-independent statistics
mysql.innodb_index_stats	Data related to particular persistent index statistics, multiple rows for each index.
mysql.innodb_table_stats	Data related to persistent indexes, one row per table.
mysql.ndb_binlog_index Table	Unused by MariaDB, kept until MariaDB 10.0 for MySQL compatibility reasons
mysql.plugin Table	Plugins loaded with INSTALL SONAME, INSTALL PLUGIN or the mysql_plugin utility
mysql.proc Table	Information about stored routines.
mysql.procs_priv Table	Stored procedure and stored function privileges
mysql.proxies_priv Table	Proxy privileges.
mysql.roles_mapping Table	MariaDB roles information
mysql.servers Table	MariaDB servers
mysql.slow_log Table	Contents of the slow query log if written to table.
mysql.tables_priv Table	Table-level privileges
mysql.table_stats Table	Table stats for engine-independent statistics
mysql.time_zone Table	Time zone table in the mysql database.
mysql.time_zone_leap_second Table	Time zone leap second.
mysql.time_zone_name Table	Time zone name.
mysql.time_zone_transition Table	Time zone transition table.
mysql.time_zone_transition_type Table	Time zone transition type table.
mysql.transaction_registry Table	Used for transaction-precise versioning.
mysql.user Table	User access and global privileges.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/the-mysql-database-tables/