I am having a problem with setting up port forwarding from one of our local CentOS machines to an AWS EC2 instance. We are wanting to make mysql connections over an SSH tunnel.
In this case, lets say that hostA is our local machine, and hostB is the Amazon EC2 instance. I have tried several different variations (that I have found from google searching), including:
from hostA: SSH -L 22222:hostB:3306 user@hostB
from hostA: SSH -L 22222:localhost:3306 user@hostB
from hostA: SSH -L 22222:hostB:3306 user@localhost
No matter which variation I have tried, in every case, it will actually create an SSH connection to the hostB, and log me into hostB, giving me its prompt. If I try the port (22222) for the localhost (hostA) in another terminal window, it doesn’t allow the connection. netstat also doesn’t show port 22222 to be opened on the local machine (hostA).
I have turned on AllowTcpForwarding on both the remote machine and the local machine.
I have also made sure that port 22222 is opened on both machine firewalls (including the EC2 security group).
What am I doing incorrectly or missing?