MySQL List Databases

by on April 12, 2008 · 3 comments· LAST UPDATED May 12, 2008

in , ,

Q. How do I display a list of all databases under MySQL Server?

A. Use show databases sql command. First you need to login as mysql database root user using mysql command line client. Type the following command to login with a password at a shell prompt:

$ mysql -u root -p
At mysql prompt type the following command:
mysql> show databases;
Sample output:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| wiki               |
+--------------------+
3 rows in set (0.03 sec)
TwitterFacebookGoogle+PDF versionFound an error/typo on this page? Help us!

{ 3 comments… read them below or add one }

1 Ramanan July 4, 2008 at 7:04 pm

for me some of the databases are not listing wven though complete privilleges are given and i checked same on mysql.db table also .Please help me out

Reply

2 budacsik September 20, 2008 at 2:50 pm

from script

mysql -u username -pxxxxxx -Bse ‘show databases’

Reply

3 seafangs February 7, 2012 at 4:26 pm

thanks :)

Reply

Leave a Comment

Tagged as: , , , , , , , ,

Previous Faq:

Next Faq: