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>
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.