: 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
-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
@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
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
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 databases
from there using the DBI
Of
Anthony Ettinger
Sent: Tuesday, 10 January 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
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