MySQL: Number of Databases
The query to find the total number of databases can be found by executing the following query:
select count(*) from information_schema.SCHEMATA where schema_name not in
('mysql','information_schema');
The query to find the total number of databases can be found by executing the following query:
select count(*) from information_schema.SCHEMATA where schema_name not in
('mysql','information_schema');