Re: SSH tunnel for Mysql

2005-12-08 Thread Cal Evans
Jerry, SQLYog is great, I use it all the time. I've been on the BETA team for 3 years now and I buy at least one copy at every company I work for. Well worth the money if you are a serious MySQL developer. However, to answer your question, google for putty.exe. The docs explain to you how to

Re: SSH tunnel for Mysql

2005-12-08 Thread Karam Chand
If you are looking for a client to connect to MySQL using SSH tunnel, try out SQLyog. It has SSH Tunneling. Karam --- Jerry Swanson <[EMAIL PROTECTED]> wrote: > How to create ssh tunnel for Mysql? > TH > __ Do You Yahoo!? Tired of spam? Yahoo!

Re: SSH tunnel for Mysql

2005-11-22 Thread Dan Bolser
Jerry Swanson wrote: Both Linux computers. This is what I do... $ more ssh_to_mysql_on_beta #!/bin/sh ssh \ -t \ -g \ -L 3306:beta.domain.ac.uk:3306 \ [EMAIL PROTECTED] \ "./bin/sleep.plx mysql" That last line is a trick to prevent the terminal from 'timeing out'. The sleep.plx applic

Re: SSH tunnel for Mysql

2005-11-21 Thread Jerry Swanson
Both Linux computers. On 11/21/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > Hello. > > > > You have not specified what operating system you're using. MySQL manual > > has some notes for Windows: > > http://dev.mysql.com/doc/refman/5.0/en/windows-and-ssh.html > > > > Jerry Swanson wrote: > >

Re: SSH tunnel for Mysql

2005-11-21 Thread Gleb Paharenko
Hello. You have not specified what operating system you're using. MySQL manual has some notes for Windows: http://dev.mysql.com/doc/refman/5.0/en/windows-and-ssh.html Jerry Swanson wrote: >How to create ssh tunnel for Mysql? >TH -- For technical support contracts, goto https://ord

Re: SSH tunnel for Mysql

2005-11-20 Thread Daniel Walker
Well, off the top of my head, to achieve a local-forwarding, you'd do something like: ssh [EMAIL PROTECTED] -L :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 pe

Re: SSH tunnel for Mysql

2005-11-20 Thread Rhino
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

Re: SSH tunnel for Mysql

2005-11-20 Thread Lee Zelyck
Are you connecting from a Windows based machine? Are you using a graphical interface? I just helped a coworker do this with Navicat. You just set it up to log into the computer hosting mysql via ssh, this creates the tunnel. Then, you configure navicat to use localhost port 3306 to connect to

RE: SSH tunnel MySQL traffic..

2002-01-04 Thread Heo, Jungsu Mr.
Hi~ I have trouble with ssh tunneling. I run this command as you told. [wertyu@inos ~]$ ssh -L 12345:localhost:3306 localhost Secure connection to localhost refused; reverting to insecure method. Using rsh. WARNING: Connection will not be encrypted. localhost: Connection refused what's the pr

RE: SSH tunnel MySQL traffic: BOTH remote & local?

2002-01-03 Thread Hershey, Ernie
localhost, with something like: mysql -h localhost -P -u otherserverusername otherserverdatabasename. Ernie Hershey -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 11:56 AM To: MySQL baby Cc: [EMAIL PROTECTED] Subject: Re: SSH

RE: SSH tunnel MySQL traffic: BOTH remote & local?

2002-01-03 Thread John Barton
Try mapping your remote mysql to a different local port, then specify that port number when you connect. For example: 'ssh -L 3307:hostip:3306 hostname' will map port 3306 on the remote machine to port 3307 on your local machine. Then, use 'mysql -P 3307 -u x -p etc.' to connect to port 3307

Re: SSH tunnel MySQL traffic: BOTH remote & local?

2002-01-03 Thread Gerald Clark
You use a different port # for the tunnel. MySQL baby wrote: > If I've got one computer with MySQL client and server on it, running everything >localhost, > > but I want to reach out to another MySQL server, through an SSH tunnel, for some >things, > > does anyone know how to differentiate

RE: SSH tunnel MySQL traffic: BOTH remote & local?

2002-01-03 Thread Gary . Every
Using the -h should do it. mysql -h 10.129.0.2 -u user -p password yadayadayada -Original Message- From: MySQL baby [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 10:28 AM To: [EMAIL PROTECTED] Subject: SSH tunnel MySQL traffic: BOTH remote & local? If I've got one compute

Re: SSH tunnel

2001-07-07 Thread Caroline Leclerc
Hi, I have come accross my problem with the port forwarding... Thanks to the help I got. I needed the flag -n (that tells ssh not to listen on stdin). So doing the following is working... assuming that you have privileges without passphrase between the server and the client... ssh -l username

Re: SSH tunnel

2001-07-04 Thread Duncan Hill
On Wed, 4 Jul 2001, Caroline Leclerc wrote: > Hi, > > Sorry to send this mail to the mailing list but I browsed all the > archives concerning a secure connection without success. > I did the following: > ssh -l username mysqlserver -L 222:mysqlserver:3306 -N a) Try using port 3306 locally if yo