Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 5.4 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 12.5.5 SHOW Syntax
- 12.5.5.1 SHOW BINARY LOGS Syntax
- 12.5.5.2 SHOW BINLOG EVENTS Syntax
- 12.5.5.3 SHOW CHARACTER SET Syntax
- 12.5.5.4 SHOW COLLATION Syntax
- 12.5.5.5 SHOW COLUMNS Syntax
- 12.5.5.6 SHOW CREATE DATABASE Syntax
- 12.5.5.7 SHOW CREATE TABLE Syntax
- 12.5.5.8 SHOW DATABASES Syntax
- 12.5.5.9 SHOW ENGINE Syntax
- 12.5.5.10 SHOW ENGINES Syntax
- 12.5.5.11 SHOW ERRORS Syntax
- 12.5.5.12 SHOW GRANTS Syntax
- 12.5.5.13 SHOW INDEX Syntax
- 12.5.5.14 SHOW INNODB STATUS Syntax
- 12.5.5.15 SHOW LOGS Syntax
- 12.5.5.16 SHOW MASTER STATUS Syntax
- 12.5.5.17 SHOW OPEN TABLES Syntax
- 12.5.5.18 SHOW PRIVILEGES Syntax
- 12.5.5.19 SHOW PROCESSLIST Syntax
- 12.5.5.20 SHOW SLAVE HOSTS Syntax
- 12.5.5.21 SHOW SLAVE STATUS Syntax
- 12.5.5.22 SHOW STATUS Syntax
- 12.5.5.23 SHOW TABLE STATUS Syntax
- 12.5.5.24 SHOW TABLES Syntax
- 12.5.5.25 SHOW VARIABLES Syntax
- 12.5.5.26 SHOW WARNINGS Syntax
SHOW DATABASES [LIKE 'pattern']
SHOW DATABASES lists the
databases on the MySQL server host. As of MySQL 4.0.2, you see
only those databases for which you have some kind of privilege,
if you do not 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.
MySQL implements databases as directories in the data directory, so this statement simply lists directories in that location. However, the output may include names of directories that do not correspond to actual databases.
User Comments
Add your own comment.