Connect to remote MySQL using proxy
- by hypeflow
I'm trying to connect to a remote MySQL server (with TCP access limited to a specific IP) using port forwarding via SSH, but still haven't figured out how to do it.
Here's what I intend to do:
Local[A] ---> Proxy[B] ---> Remote MySQL[C]
[A] Local machine with Windows
[B] CentOS machine with IP 123.123.123.1 (with it's own MySQL running, btw)
[C] Remote MySQL server with IP 123.123.123.1 authorized on port 3306
How to achieve this?
Thanks in advance.