---
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> Anthony Ettinger
> Sent: Tuesday, 10 January 2006 9:33 AM
> To: Logan, David (SST - Adelaide)
> Cc: Mikhail Berman; mysql@lists.my
nuary 2006 9:33 AM
To: Logan, David (SST - Adelaide)
Cc: Mikhail Berman; mysql@lists.mysql.com
Subject: Re: remotely show databases
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 dat
--
>
> -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 DAT
@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 installat
[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@lis
: 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 databas
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 DATABAS
