MySQL – List Database
When you connect to a MySQL server using the MySQL client, you can run the SHOW DATABASES command to obtain a list of the MySQL databases.
Enter your MySQL password when prompted and access the MySQL server using the following command:
mysql -u user -p
The following command should be executed from within the MySQL shell:
In order to list all the databases on the MySQL server, you must be logged in as a user who can access all databases, which is by default the MySQL root user, or set a global privilege called SHOW DATABASES.
Filtering the Result
By using the LIKE clause, you can filter the output of SHOW DATABASES based on a particular pattern.
SHOW DATABASES LIKE pattern;
The following statement will return all databases with names beginning with the letter ‘Demo’, for example:
SHOW DATABASES LIKE 'emp%';