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 email@example.com 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
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.