|
Display a list of databases on a MySQL server |
|
|
|
|
Written by Amanatullah khalil
|
|
Sunday, 24 May 2009 |
|
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). courtesy http://www.tech-recipes.com/rx/274/display-a-list-of-databases-on-a-mysql-server/
|
Articles 
