If you had another tunnel open, or MySQL running locally on your computer, then it may be that other MySQL server that's rejecting your authentication attemptsġ. When you connect to the mysql server on, you're actually accessing it via 127.0.0.1, i.e. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |