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:

Answer 2

In MySQL you do not have a "default database." The default is the one you specify as part of your session.

1. Selecting a Database: You can switch the default database using the `USE` statement:

USE my_database;

3. Connection String: To specify the default database on your connection string, you would do something like this:

mysql -u username -p my_database
 

3. No Implicit Default: The statements using a database fail if no database has been chosen.

The MySQL client takes the database chosen by `USE` or specified in the connection parameters as default for the session