[ Enlarge Image ]
<< Back
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 ]