24.22 The INFORMATION_SCHEMA SCHEMATA Table
A schema is a database, so the
SCHEMATA table provides information about databases.
SCHEMATA table has these columns:
The name of the catalog to which the schema belongs. This value is always
The name of the schema.
The schema default character set.
The schema default collation.
This value is always
SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE 'wild']
You see only those databases for which you have some kind of privilege, unless you have the global
SHOW DATABASES privilege.