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