About Linux FAQ

Browse More FAQs:

MySQL List Databases

Posted by Vivek Gite [Last updated: May 12, 2008]

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)

Subscribe to our free e-mail newsletter or RSS feed to get all updates. You can Email this page to a friend.

Related Other Helpful FAQs:

Discussion on This FAQ

  1. Ramanan Says:

    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

Leave a Reply

We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Tags: , , , , , , , ,

Copyright © 2006-2008 nixCraft. All rights reserved - TOS/Disclaimer - Privacy policy - Sitemap - Powered by Open source software.