MySQL Workbench throws: “Failed top Connect to MySQL at 127.0.0.1:3306 through SSH tunnel at firstname.lastname@example.org 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.