Display a list of databases on a MySQL server

This is how to list the databases that exist in a MySQL server, use the ‘show databases‘ SQL command:

show databases;
+——————+
| Database                |
+——————+
| database1              |
| mysql                     |
| test                         |
+——————+

It will display all the databases your user has access to


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image