13.5.4.9. SHOW DATABASES Syntax
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern']
SHOW DATABASES lists the databases on the
MySQL server host. You see only those databases for which you
have some kind of privilege, unless you have the global
SHOW DATABASES privilege. You can also get
this list using the mysqlshow command.
If the server was started with the
--skip-show-database option, you cannot use
this statement at all unless you have the SHOW
DATABASES privilege.
SHOW SCHEMAS can also be used.
