Method One: Use the SECURECRT Client tool to connect to the staging server through the SECURECRT tool and create an SSH turnal.
1. Select New Portforwarding on the session that can be connected to the relay server.
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/7F/DC/wKiom1cwFVWCa6OIAAC55632kxo958.png "style=" float: none; "title=" 1.png "alt=" Wkiom1cwfvwca6oiaac55632kxo958.png "/>
2. Just a name, fill in the local IP 127.0.0.1 port on the locally to fill out an unused port, remote is the host and port of the MySQL server to connect to the road.
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/7F/D9/wKioL1cwFjLCBKY_AADNXuHz24Y450.png "style=" float: none; "title=" 2.png "alt=" Wkiol1cwfjlcbky_aadnxuhz24y450.png "/>
3. The client in window fills in the above local host IP and Port 9987, username and password are MySQL authorized user name and password, above secure to medium connecting connection to open.
650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/7F/DC/wKiom1cwFVaybqYjAABtpe_j8W4783.png "style=" float: none; "title=" 3.png "alt=" Wkiom1cwfvaybqyjaabtpe_j8w4783.png "/>
4. The connection was successful.
650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/7F/D9/wKioL1cwFjPgQUnBAADfT389TlU383.png "style=" float: none; "title=" 4.png "alt=" Wkiol1cwfjpgqunbaadft389tlu383.png "/>
Method Two: Using the Mysqlproxy tool
[Email protected] ~]# wget http://cdn.mysql.com/archives/mysql-proxy/mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz
[Email protected] ~]# Tar XF mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz
[Email protected] ~]# CD Mysql-proxy-0.8.5-linux-el6-x86-64bit
[Email protected] mysql-proxy-0.8.5-linux-el6-x86-64bit]#/bin/mysql-proxy--help-all
-B,--proxy-backend-addresses=
#./bin/mysql-proxy--proxy-backend-addresses=192.168.1.212:3306 &
# NETSTAT-NLP
# NETSTAT-NLP | grep 4040
TCP 0 0 0.0.0.0:4040 0.0.0.0:* LISTEN 21883/mysql-proxy
In the window client connection
650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/7F/DC/wKiom1cwG8OxhQ3KAABqhzoNkz8741.png "title=" 5.png " alt= "Wkiom1cwg8oxhq3kaabqhzonkz8741.png"/>
Connection succeeded:
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/7F/DC/wKiom1cwHBLTYEalAADMKjkZDGo782.png "title=" 6.png " alt= "Wkiom1cwhbltyealaadmkjkzdgo782.png"/>
Client Access to intranet database