Connect to remote MySQL using proxy

Question

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?

Answer 1

Use PuTTY's port forwarding to forward local port 3306 to port 3306 of machine C, connecting to machine B. If using the command line ssh use:

ssh -L 3306:machineC:3306 username@machineB 

then connect to MySQL via localhost:3306.