Thursday, June 20, 2024
HomeDatabaseMySQLDisplay a list of databases on a MySQL server

Display a list of databases on a MySQL server

Use the ‘show databases’ command to display the list of dbs on the server.

To list the databases that exist in a MySQL server, use the ‘show databases’ SQL command:

show databases;
| Database |
| financial |
| mysql |
| test |

The mysql database holds user priviledge information and is required for operation of MySQL. The command can be issued from any SQL source including an application with database connectivity (i.e., PHP, Java, etc.) or directly from mysql command (see Connect to a MySQL server using the mysql command for more information).

Quinn McHenry
Quinn McHenry
Quinn was one of the original co-founders of Tech-Recipes. He is currently crafting iOS applications as a senior developer at Small Planet Digital in Brooklyn, New York.


Please enter your comment!
Please enter your name here

Most Popular


Recent Comments

error: Content is protected !!