Shulou(Shulou.com)06/01 Report--

Method 1: Use SecureCRT client tools to connect to the transit server through SecureCRT tools and create SSH Turnal.

1. Select New PortForwarding on the session that can connect to the transit server.

Xshell settings, this is Chinese.

2. Just pick a name, fill in the local ip 127.0.0.1 port, fill in an unused port, Remote is the host and port of the mysql server to connect to the channel.

How to set up Xshell

3. Fill in the local host IP and port 9987 above in the client side of the window, the username and password are mysql authorized username and password, and the connection to the relay machine above is to be opened.

4. Connection successful.

Method 2: Use MysqlProxy

[root@localhost ~]# wget http://cdn.mysql.com/archives/mysql-proxy/mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz

[root@localhost ~]# tar xf mysql-proxy-0.8.5-linux-el6-x86-64bit.tar.gz

[root@localhost ~]# cd mysql-proxy-0.8.5-linux-el6-x86-64bit

[root@localhost 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

Client connections in window

Connection successful:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.