Show all databases in MySQL

Getting the information of installed databases first step to check whether database exists or not. if database with same name exists then we can change the database which is going to be create.Show databases in MySQL will help this.

To see all the databases in MySQL, we will use show databases command.

Show databases;

It will show output like below


Databases name will be different according to the databases installed in your system.

Scroll to Top