List:General Discussion« Previous MessageNext Message »
From:Sherwin T. Ang Date:December 10 2002 5:45am
Subject:Re: How to get MySQL to list current db's ?
View as plain text  
You can either use
mysql>show databases;

or mysqlshow -uroot -p  in the command line.

Respectfully yours,

Sherwin T. Ang
Systems Administrator
Internet Manila

----- Original Message -----
From: "Will Standley" <wstandley@stripped>
To: "MySQL List" <mysql@stripped>
Sent: Tuesday, December 10, 2002 12:35 AM
Subject: How to get MySQL to list current db's ?


> I have two sample MySQL db's running on a local Linux box w/Apache...
>
> Once I enter "mysql" from the Linux command line...
>
> Is there a way to ask MySQL to list the db's that are currently created?
>
> Thanks,
>
> 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 <mysql-thread127070@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-sherwin=fax.alchemy.com.ph@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
access->mysqlSandeep Murphy4 Dec
  • Re: access->mysqlSteve Yates4 Dec
  • Re: access->mysqlCrercio O. Silva5 Dec
RE: access->mysqlSteve Bradwell4 Dec
RE: access->mysqlDavid Brodbeck4 Dec
RE: access->mysqlIan Zabel4 Dec
  • Re: access->mysqlCarlin Anderson5 Dec
RE: access->mysqlChris Couture5 Dec
RE: access->mysqlSandeep Murphy5 Dec
  • How is DBTools Software?Will Standley7 Dec
    • Re: How is DBTools Software?Michael She7 Dec
      • RE: How is DBTools Software?Chris Mason8 Dec
        • Re: How is DBTools Software?Insanely Great8 Dec
        • RE: How is DBTools Software?Michael She8 Dec
  • Compiling a list of MySQL tools - Please contribute.Will Standley8 Dec
    • Re: Compiling a list of MySQL tools - Please contribute.Paul DuBois8 Dec
  • Can u us a "source code" file to setup a db in MySQL ?TopMailBox9 Dec
    • Re: Can u us a "source code" file to setup a db in MySQL ?Gerald R. Jensen9 Dec
      • How to get MySQL to list current db's ?Will Standley10 Dec
        • Re: How to get MySQL to list current db's ?Sherwin T. Ang10 Dec
        • Re: How to get MySQL to list current db's ?Daniel Kiss10 Dec
        • Re: How to get MySQL to list current db's ?Michael She10 Dec
          • Where does MySQL store db files?tmb10 Dec
            • How to see # of rec's in all tablestmb10 Dec
              • Re: How to see # of rec's in all tablesBenjamin Pflugmann11 Dec
              • re: How to see # of rec's in all tablesVictoria Reznichenko11 Dec
            • Re: Where does MySQL store db files?Robert Citek10 Dec
              • Re: Where does MySQL store db files?Francisco10 Dec
            • RE: Where does MySQL store db files?Adolfo Bello10 Dec
        • RE: How to get MySQL to list current db's ?Brian P. Austin10 Dec
  • Re: access->mysqlGrant Cooper13 Dec