MySQL – How to Connect to Remote MySQL Server Using Socks Proxy

macmac-osxMySQLPROXYUbuntu

I can only connect to a remote server from an specific IP address (Ubuntu Server), this was okay when I was at office but now that I'm working from home I'm stuck.

I have SSH access to the Ubuntu server with this specific IP address, so I connected to it using SSH Proxy (which provides local Socks 5 proxy).

So far I have found ways to connect to SSH and FTP (using FileZilla, which supports Socks Proxy)

But I have found no macOS MySQL GUI app that supports socks 5 proxy.

Please advise.

Best Answer

You can either use open-ssh local tunneling. You can use option -L in command line or LocalForward in ~/.ssh/config

ssh -L 33060:mysql_server_ip:3306

Then use localhost:33060 in MySQL clients as server:port string.

Another alternative is to use MySQL Workbench with ssh tunneling.

Related Solutions

Ubuntu – Using ssh and corkscrew/proxychains behing a HTTP proxy

Solution is quite simple after all: make ssh connect to proxy ONLY when it needs to establish a tunnel for the first time:

ssh_config:

Host external-host.com
    ProxyCommand corkscrew corp.proxy.ip 8080 %h %p

That works cool.

Thanks for watching, everybody :)

Php – Making a socks proxy using PHP

This isn't something that can really work over a HTTP connection. Most HTTP servers are made to serve short lived connections and a SOCKS proxy is going to need the connection to stay open.

Best Answer

Related Solutions

Ubuntu – Using ssh and corkscrew/proxychains behing a HTTP proxy

Php – Making a socks proxy using PHP

Related Topic