- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 3.23, 4.0, 4.1 Reference Manual :: 12 SQL Statement Syntax :: 12.5 Database Administration Statements :: 12.5.5 SHOW Syntax :: 12.5.5.8 SHOW DATABASES Syntax
Section Navigation [Toggle]
- 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.
© 1995-2008 MySQL AB. All rights reserved.
User Comments
Add your own comment.