System Databases

The following databases exist for MySQL’s use. You may read (SELECT) them, but you must not write (INSERT/UPDATE/DELETE) the tables in them. (There are a few exceptions.)

mysql – repository for GRANT info and some other things.
information_schema – The tables here are ‘virtual’ in the sense that they are actually manifested by in-memory structures. Their contents include the schema for all tables.
performance_schema – ?? [please accept, then edit]
others?? (for MariaDB, Galera, TokuDB, etc)

Found a mistake? Have a question or improvement idea? Let me know.

Creating Databases:

*Creating databases

*Create database users and grants

*System Databases

*Creating and Selecting a Database

Table Of Contents

0Getting started with MySQL

1Limit and Offset

2Creating Databases

3Backup using mysqldump

4Table Creation

7Stored routines, procedures and functions

8Reserved Words

9String operations

12Indexes and Keys

13Date and Time Operations

15LOAD DATA INFILE

16PREPARE Statements

20Change Password

24Pivot Queries

25Configuration and tuning

26Converting from MyISAM to InnoDB

28Create New User

33Performance Tuning

36Install MySQL with Docker

38Character Sets and Collations

39MyISAM Engine

40Many-to-many Mapping table

41Using Variables

44Security via GRANTs

47MySQL LOCK TABLE

51MySQL Performance Tips

52Temporary Tables

54Customize PS1

55Dealing with sparse or missing data

56Dynamic Un-Pivot Table using Prepared Statement

59Connecting with UTF-8

60SSL Connection Setup

61Handling Time Zones

62Time with subsecond precision

63Error 1055 ONLY FULL GROUP BY

64Full-Text search

65Extract values from JSON type

66Regular Expressions

67Recover and reset default root password

69JOINS Join 3 tables

70Server Information

71Recover from lost root password