Working with the MySQL server, it is a common task to view or list the available databases. We can view all the databases on the MySQL server host using the following command:
mysql> SHOW DATABASES;
To view the list of databases in MySQL, you can use the following SQL command:
SHOW DATABASES;
Executing this command in the MySQL command-line interface (CLI) will display a list of databases available on the server.