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