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:
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.
If you want to learn MySQL from top professionals, then check out this SQL Certification program by Intellipaat.
Also, watch this video on MySQL: