You could use a query on the magic
INFORMATION_SCHEMA
database to get the number (see below), or just count the number of rows returned from
SHOW DATABASES
.
Example Query:
Code:
SELECT COUNT(SCHEMA_NAME) AS `Databases` FROM INFORMATION_SCHEMA.SCHEMATA;
Example Returns:
Code:
+-----------+
| Databases |
+-----------+
| 2 |
+-----------+