To list the databases that exist in a MySQL server, use the show databases SQL command: show databases;
From the command line, begin by logging into MYSQL using the command
mysql -u [USERNAME] -p
Where -u [USERNAME] is the administrative user for the MYSQL instance and -p forces a password request.
mysql> show databases;
+—————–+
| Database |
+—————–+
| financial |
| mysql |
| test |
+—————–+
