MySQL Command to List existing db's = ??

2002-12-09 Thread wstandley . ws
I have a Linux/Apache/MySQL box with a number of MySQL db's on it... all were created 
by someone else expermenting with MySQL...

I'm not sure of all the names of the db's on the system...

Is there a MySQL command to List the names of all the MySQL db's on the box?

The system is not on the net... it is local and to be used for off line development 
work.

thanks for any info - Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: MySQL Command to List existing db's = ??

2002-12-09 Thread Roger Davis
If I understand right try..

SHOW DATABASES;

The mysql and test database are installed by default.

Hope this helps

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 8:12 PM
To: [EMAIL PROTECTED]
Subject: MySQL Command to List existing db's = ??


I have a Linux/Apache/MySQL box with a number of MySQL db's on it... all
were created by someone else expermenting with MySQL...

I'm not sure of all the names of the db's on the system...

Is there a MySQL command to List the names of all the MySQL db's on the
box?

The system is not on the net... it is local and to be used for off line
development work.

thanks for any info - Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php