[ Enlarge Image ]  
 
 
<< Back 
Posted: 2005/09/22 by: fcruz. MySQL Blogs.
Lately im trying to document as many 'quick tips' as i can, and this is a small command that I actually forgot while running some database checks the other day, as simple as it is I had to 'google' it to remember, so i might as well document it right here no ??
Directions -
To list the databases that exist in a MySQL server, use the 'show databases' SQL command:

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


For the newbies, to run this command you need to be under the mysql terminal, to connect to the mysql t erminal use the following command:

mysql -h localhost -uyouruser -pyourpass

As usual , hope it helps

Felipe





[ Back ]