mysql database is the system database. It
contains tables that store information required by the MySQL
server as it runs.
Tables in the
mysql database fall into these
The remainder of this section enumerates the tables in each
category, with cross references for additional information. System
tables use the
MyISAM storage engine.
Do not convert MySQL system tables in the
mysql database from
InnoDB tables. This is an unsupported
operation. If you do this, MySQL does not restart until you
restore the old system tables from a backup or regenerate them
by reinitializing the data directory (see
Section 2.10.1, “Initializing the Data Directory”).
These system tables contain grant information about user accounts and the privileges held by them:
For more information about the structure, contents, and purpose of the grant tables, see Section 6.2.3, “Grant Tables”.
These system tables contain information about stored programs, user-defined functions, and server-side plugins:
event: Information about Event Scheduler events. See Section 20.4, “Using the Event Scheduler”. The server loads events listed in this table during its startup sequence, unless started with the
func: Information about user-defined functions (UDFs). See Section 24.4, “Adding Functions to MySQL”. The server loads UDFs listed in this table during its startup sequence, unless started with the
plugin: Information about server-side plugins. See Section 5.5.1, “Installing and Uninstalling Plugins”, and Section 24.2, “The MySQL Plugin API”. The server loads plugins listed in this table during its startup sequence, unless started with the
proc: Information about stored procedures and functions. See Section 20.2, “Using Stored Routines”.
The server uses these system tables for logging:
Log tables use the
CSV storage engine.
For more information, see Section 5.4, “MySQL Server Logs”.
These system tables contain server-side help information:
For more information, see Section 5.1.13, “Server-Side Help Support”.
These system tables contain time zone information:
For more information, see Section 5.1.12, “MySQL Server Time Zone Support”.
The server uses the
table to store binary log information for NDB Cluster
Section 18.6.4, “NDB Cluster Replication Schema and Tables”.
Other system tables do not fall into the preceding categories:
servers: Used by the
FEDERATEDstorage engine. See Section 188.8.131.52, “Creating a FEDERATED Table Using CREATE SERVER”.