Question

Connect to MySQL via SSH from MySQL Workbench

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>

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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:

echo "AllowTcpForwarding yes" >> /etc/ssh/sshd_config
systemctl restart ssh

Then try making the connection again in your application and see if that helps.

Jarland