Well, off the top of my head, to achieve a local-forwarding, you'd do
something like:
ssh [EMAIL PROTECTED] -L <arbitrary high port no>:localhost:3306 -N &
Remember, "localhost" is resolved after the tunnel is established, so
refers, actually, to the remote machine :) (The -N option simply
obviates the need to perform some useless execution at the remote
end, like "sleep 9999" or somesuch nonesense).
An example:
ssh [EMAIL PROTECTED] -L 3776:localhost:3306 -N &
On 20 Nov 2005, at 19:38, Rhino wrote:
I use PuTTY (and WinSCP3) to attach my Windows machine to the Linux
server holding my MySQL database. PuTTY is used to get the command
line and WinSCP3 is the GUI I can use to do file transfers between
the two machines.
In PuTTY, there is a place where you can create SSH tunnels; it is
located in the Connection/SSH/Tunnels page of the settings tree.
You just use the bottom half of the Port Forwarding section of that
screen to "add" new forwarded ports, specifying the source port,
the destination, and choosing one of local, remote, or dynamic;
then click Add and you should be ready to go.
WinSCP3 also has an SSH section in its settings tree but I've never
touched the defaults or set up a tunnel for it and it works fine.
Rhino
----- Original Message ----- From: "Jerry Swanson" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Sunday, November 20, 2005 10:00 AM
Subject: SSH tunnel for Mysql
How to create ssh tunnel for Mysql?
TH
----------------------------------------------------------------------
----------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.4/176 - Release Date:
20/11/2005
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.4/176 - Release Date:
20/11/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]