Re: SSH tunnel for Mysql
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 create a tunnel, I believe the switch you are looking for is -L. It's not difficult. =C= | | Cal Evans | http://www.calevans.com | Karam Chand wrote: 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! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SSH tunnel for Mysql
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! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SSH tunnel for Mysql
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 application is just a little perl script which writes "sleeping $ARGV[0]\n" every 5 minuites. Running the above on my local machine (linux) allows me to connect to mysql on 'local' port 3306, and have that magically redirected via ssh to beta port 3306. Dan. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SSH tunnel for Mysql
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: > > > > >How to create ssh tunnel for Mysql? > > >TH > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com <http://www.mysql.com> > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
Re: SSH tunnel for Mysql
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://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SSH tunnel for Mysql
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 perform some useless execution at the remote end, like "sleep " 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: 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]
Re: SSH tunnel for Mysql
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: 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/[EMAIL PROTECTED]
Re: SSH tunnel for Mysql
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 mysql. Your done. Not sure how you would do it with other pructs, but I don't imagine it would be much more difficult. Lee --- Jerry Swanson <[EMAIL PROTECTED]> wrote: > How to create ssh tunnel for Mysql? > TH > __ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SSH tunnel for Mysql
How to create ssh tunnel for Mysql? TH
