Re: [gnome-db] how do I access using ssh

[Rodrigo Moya <rodrigo gnome-db org>]

On Fri, 2003-09-05 at 01:07 -0400, Chris Bruner wrote:
> I'm interested in using Gnome-db, but I can't connect to my database except 
> through ssh. (mysql)
> 
> Is there a way (script?) to access mysql on another system piping through ssh?
> 
you mean you only have access to that system by creating a ssh tunnel?
If so, just do:

ssh -f -L $local_port:$unreachable_host:$remote_port
$user $intermediary_host sleep 60 </dev/null >/dev/null

Then connect to MySQL on localhost:$local_port

If you have access to that host, but need to use SSH, maybe it might
work using the USE_SSL parameter in the MySQL connection string for the
libgda data source.

cheers