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