[TCLUG] tuneling mysql though ssh

[Thomas T. Veldhouse]

hermes-1% ssh -L 3306:hermes.sistina.com:3306 bender.sistina.com
hermes-2% mysql -h hermes.sistina.com -u$USERNAME --p$PASSWORD

Assumes that you can open a local socket on 3306.

Tom Veldhouse
veldy at veldy.net

----- Original Message -----
From: "Ben Lutgens" <blutgens at sistina.com>
To: <tclug-list at mn-linux.org>
Sent: Thursday, March 08, 2001 3:52 PM
Subject: Re: [TCLUG] tuneling mysql though ssh

On Thu, Mar 08, 2001 at 03:44:45PM -0600, Thomas T. Veldhouse wrote:
>MySQL will get the servername of where ever sshd is running.  I do this all
>the time -- allows me a local ODBC connection accross ssh to MySQL running
>on a different firewalled machine.

o.k. so what mysql command do you use?

>
>Tom Veldhouse
>veldy at veldy.net