I'm trying to connect to my database via SSH tunneling from one of our web app servers with MySQL Workbench. Here's the basic config; note that I changed some values in the screenshot for security reasons.
The problem is every time I try to connect over an SSH tunnel from one of our app servers, I get the following error:
Failed to connect to us-east-1.amazonaws.com through SSH tunnel at computer.amazonaws.com with user social_shop_prod. Can't connect to MySQL server on 127.0.0.1.
However, if I use the same credentials over SSH via the following command line:
mysql -u social_shop_prod -h us-east-1.amazonaws.com -p
I can connect successfully and get the MySQL interactive command prompt.
Been talking with the rest of my development team here and none of us can figure out why I can't tunnel over SSH from our app servers with Workbench; but when I SSH to one of our app servers and connect to MySQL via the command line; I can connect successfully.
And why is it trying to connect over 127.0.0.1? I didn't specify that in the configuration; nor is my hosts file redirecting the domains shown below to that IP.
Any constructive input is greatly appreciated.