Cry MySQL How to...

List all the databases

To list all of the databases on the server currently connected to, use the following SQL:

show databases;

This will return a query result containing the names of all of each of the databases.

Alternatively (from MySQL 5) you could also use:

select SCHEMA_NAME from INFORMATION_SCHEMA.SCHEMATA

These notes have been tested against MySQL version 4 and 5.0.