![connect to mysql database workbench on my computer connect to mysql database workbench on my computer](https://i.ytimg.com/vi/d24vyqUSqfI/maxresdefault.jpg)
When you connect to the mysql server on, you're actually accessing it via 127.0.0.1, i.e.
![connect to mysql database workbench on my computer connect to mysql database workbench on my computer](https://i1.wp.com/thedbadmin.com/wp-content/uploads/2020/03/17setup.png)
The ip address of your computer is 127.0.0.1 or localhost. Since you are connecting through a SSH tunnel, this means that the MySQL port 3306 from is being opened locally on your computer. I can connect successfully and get the MySQL interactive command prompt.īeen 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.Īnd 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.Īny constructive input is greatly appreciated. However, if I use the same credentials over SSH via the following command line: mysql -u social_shop_prod -h -p Can't connect to MySQL server on 127.0.0.1. The problem is every time I try to connect over an SSH tunnel from one of our app servers, I get the following error:įailed to connect to through SSH tunnel at with user social_shop_prod. Here's the basic config note that I changed some values in the screenshot for security reasons. I'm trying to connect to my database via SSH tunneling from one of our web app servers with MySQL Workbench.