Table of Contents:


    Follow us

    Default databases in MySQL

    2018-10-02 2019-01-30
    This applies to MySQL. Article available also for: SQL Server

    Every MySQL is shipped with default system schemas/databases. Those are:

    • mysql - is the system database that contains tables that store information required by the MySQL server
    • information_schema - provides access to database metadata
    • performance_schema - is a feature for monitoring MySQL Server execution at a low level
    • sys - a set of objects that helps DBAs and developers interpret data collected by the Performance Schema

    Please note that some database tools hide system schemas by default. Using MySQL Workbench for instance you will not see them in the Object Browser unless you change settings. However, you have access to those schemas and you can query tables and views right away. For instance:

    select * from information_schema.tables
    

    Share this article

    0
    There are no comments. Click here to write the first comment.