What is the default database in MySQL?

Question

Can anyone explain what is the default database in MySQL?

Answer 1

You can use the SHOW DATABASES statement lists all databases in the MySQL database server before you create a new database.

Here is the syntax to list all the databases in the server:

SHOW DATABASES;

You can observe the databases in the MySQL database server. The information_schema and MySQL are the default database in MySQL.

Selecting a database to work with

If you want to use a particular database you want to work with, you can do using the USE statement as below.

USE database_name;

If you want to learn MySQL from top professionals, then check out this SQL Certification program by Intellipaat.

Also, watch this video on MySQL: