For When You Can't Have The Real Thing
[ start | index | login ]
start > mysql > list databases

list databases

Created by dave. Last edited by dave, 354 days ago. Viewed 379 times. #1
[edit] [rdf]

List databases in MySQL

The most common way to get a list of the MySQL databases is by using the mysql client to connect to the MySQL server and run the SHOW DATABASES command.

$ mysql -u me -p [-h remotehost]
mysql> show databases
    -> ;
| Database           |
| information_schema |
no comments | post comment
This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.

Useful: | Copyright 2000-2002 Matthias L. Jugel and Stephan J. Schmidt