Michael-
That seems to be correct. I've been able to do this using PuTTY as the
client. Just forward the local 3306 to the server's 3306 and connect to
localhost:3306. Be sure to log to the server via ssh before attempting
a connection.
-jeff
On Thu, 2003-03-13 at 13:09, Tam, Michael wrote:
> Hi Dan and everyone,
>
> First off, I apologize for the stupid question due to my lack of technical
> knowledge on this area.
>
> What I am trying to do is to connect to a MySQL on a Win2k machine from
> another Win2k machine with SSH.
> After doing some research, I manage to grasp some idea on how to establish
> it.
> However, there are still some detail and confirmation I need to get it to
> work.
>
> First, correct me if I am wrong, I need to establish a SSH server on the
> machine which has mysql running [Done by setting up OpenSSH for Win32].
> Then I need a SSH client on a another win2k machine [Done by having
> SecureCRT on the machine]. After these, I should configure the client SSH to
> connect to the server. Then I can run pretty much any MySQL GUI client to
> connect to MySQL under SSH.
>
> To the SSH client config section, I need to setup a local forwarding and/or
> remote forwarding and this is where I am not clear how to get it right.
>
> For example,
> server PC has ip 192.168.0.100
> client PC has ip 192.168.0.101
>
> To setup local forwarding: localport:3306 remotehost: 192.168.0.100
> port: 3306
> Then I can use MySQL client to connect to 192.168.0.101:3306 to reach the
> server, am I correct?
>
> I would greatly appreciate if someone can verify these steps and correct me
> if I misunderstood any item.
>
> Thank you so much.
>
> Regards,
> Michael
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread134658@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-kilpatjr=lupus.omrf.ouhsc.edu@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
