MySQL Workbench throws: “Failed top Connect to MySQL at 127.0.0.1:3306 through SSH tunnel at root@xxx.xx.xx.xxx with user root”
I can SSH into the server using ssh key and I can login to the MySQL using the credentials when the LAMP droplet was created.
Workbench (8.0.15) settings are: SSH Hostname: <droplet ip> SSH User: root SSH Key: <my ssh key> MySQL Hostname: 127.0.0.1 MySQL port: 3306 Username: root Password: <droplet mysql pass>
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Greetings!
You may need to enable port forwarding in the SSH config. Try this:
Then try making the connection again in your application and see if that helps.
Jarland