On 1/9/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote: > > Hi Anthony, > > If you are accessing the db from perl, just execute a show databases > from there using the DBI interface. There is quite an amount of doco > about this and other features at cpan.org. You could also look at the > source for phpMyadmin as this has to get the database names to display > them. > > The advantage of the DBI interface is that with a tiny bit of work, it > will probably work with Postgresql as well. > > You could also give SELECT permission to a specific user on all > databases that is not passworded and this should allow you to list the > databases without having to send a password. > > Regards > > > --------------------------------------------------------------- > ********** _/ ********** David Logan > ******* _/ ******* ITO Delivery Specialist - Database > ***** _/ ***** Hewlett-Packard Australia Ltd > **** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] > **** _/ _/ _/ _/ **** Desk: +618 8408 4273 > **** _/ _/ _/_/_/ **** Mobile: 0417 268 665 > ***** _/ ****** > ****** _/ ******** Postal: 148 Frome Street, > ******** _/ ********** Adelaide SA 5001 > Australia > i n v e n t > --------------------------------------------------------------- > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Anthony Ettinger > Sent: Tuesday, 10 January 2006 7:40 AM > To: Mikhail Berman > Cc: mysql@lists.mysql.com > Subject: Re: remotely show databases > > 'SHOW DATABASES;' | mysql -u foo -h bar.com > > this works, I haven't tested it with other databases though. > > On 1/9/06, Mikhail Berman <[EMAIL PROTECTED]> wrote: > > > > Hi Anthony, > > > > I am not sure if you have an installation of MySQL on your local > server. > > If you do then you can try to use something like below to execute your > > "SHOW DATABASES" > > > > Local_server>[path to your mysql/bin directory]/mysql > > --host=your_remote_host --user=your_user --password=your_password -e > > "SHOW DATABASE" > > > > Make sure that [EMAIL PROTECTED] has appropriate rights on > > your_remote_host (server) > > > > Best, > > > > Mikhail Berman > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > > Anthony Ettinger > > Sent: Sunday, January 08, 2006 4:03 PM > > To: mysql@lists.mysql.com > > Subject: remotely show databases > > > > I know I can login via ssh and run $mysqlshow > > > > But I would then have to parse the outputted text, is there an easier > > way (I'm using Perl locally here). > > > > The pitfall of running it locally is that you DO have to password > > protect your database user since it's an outside connection to run > "SHOW > > DATABASES"; > > > > I tried $man mysqlshow, but didn't see any easy way of simply > returning > > a \n seperated list of databases. > > > > Any suggestions? > > > > I also need to do this for postgresql if anyone else knows of a > > standalone app that dumps the databases for a specific user. > >
Actually, for security reasons, the command has to be executed on the remote ssh server that has network access to the mysql server. Going across the Internet with DBI; may not be feasible unless you open up the access host.