Client Access to intranet database

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