What are the different tables present in MySQL?

by

There are many tables that remain present by default. But, MyISAM is the default database engine used in MySQL. There are five types of tables that are present:

  • MyISAM
  • Heap
  • Merge
  • INNO DB
  • ISAM

In MySQL, there are several default tables and system tables that are present in the database to manage its functionalities. Some of the important ones include:

  1. mysql.user: This table stores information about MySQL user accounts, including usernames, passwords, and privileges.
  2. mysql.db: It contains information about database-level privileges.
  3. mysql.tables_priv: This table stores table-level privilege information.
  4. mysql.columns_priv: It stores column-level privilege information.
  5. mysql.procs_priv: This table contains stored procedure and function privileges.
  6. mysql.roles: Introduced in MySQL 8.0, this table stores role definitions.
  7. mysql.global_priv: This table contains global privilege information.
  8. mysql.db: It stores database-level privileges.
  9. mysql.tables_priv: This table holds table-level privilege information.
  10. mysql.columns_priv: It contains column-level privilege information.
  11. mysql.procs_priv: This table stores stored procedure and function privileges.

These are just a few examples of the system tables present in MySQL. The specific tables and their purposes might vary slightly depending on the MySQL version and configuration.