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 22.214.171.124 (with it's own MySQL running, btw)
[C] Remote MySQL server with IP 126.96.36.199 authorized on port 3306
How to achieve this?
Thanks in advance.