Navicat for Mysql SSH Tunnel with a springboard machine solution

Source: Internet
Author: User
Tags ssh port

Navicat Mysql SSH tunnel can not use a springboard machine, for the need to log on the board of the host, his own SSH tunnel is a chicken. In fact, from the principle of analysis, there is no need to open his SSH tunnel, using the powerful SSH port forwarding, plus a springboard agent, can be a perfect solution.

1, first cancel the SSH tunnel already set, if all empty

2, the local configuration of Springboard machine, Springboard machine articles, Baidu can. For example, my:

Replace the host, User, 123.45.67.89, and switch to your own corresponding parameter:

VI ~/.ssh/config

Host *.mydomain.com
User Root
Proxycommand ssh [email protected] nc-q0%h%p

The meaning of this configuration is: All SSH connection *.mydomain.com domain name use a springboard, the IP of the springboard is: 123.45.67.89

For example, if I want to connect ab.mydomain.com with this example, I will use 123.45.67.89 as a springboard.

3, then, the boot local to the remote MySQL listening port, this is the focus of this article:

SSH-VNL 3367:localhost:3306 [email protected]

Explain:

-V: Displays log, which is verbose information

N: Do not log in to remote, L: Local monitoring

-VNL 3367:localhost:3306: Turn on local 3367 to remote host ab.mydomain.com:3306 port mapping.

All data destined for local 3367 ports is forwarded to ab.mydomain.com:3306

4, Navicat for Mysql configuration parameters, the port must be the same as the above 33,671. 3367 can be modified according to their own circumstances, as long as it is consistent with the above.

Windows can also, 3 of the commands mentioned, can be replaced with plink:

plink -L 3367:localhost:3306 [email protected]

Transferred from: http://www.yinqisen.cn/blog-349.html

Navicat for Mysql SSH Tunnel with a springboard machine solution

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.