Question

I cannot connect to my droplet through MySQL workbench, but I can connect through FileZilla.

Posted April 19, 2020 160 views
MySQLDigitalOcean

I am running windows and have generated an ssh key. However, when I try to establish the connection to my droplet (Through MySQL Workbench), I am receiving an error. The error is “COULD NOT CONNECT TO THE SSH TUNNEL: Authentication failed, access denied.” Any advice would be greatly appreciated.

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.

×
1 answer

Hi @noahmcdonough,

It seems like you don’t have the proper permissions.First one I could think of is not using the proper ssh key. Please make sure to use the id_rsa.pub file in order for your SSH to work.

Additionally, if you are connecting via MySQL Workbench, it means you are trying to connect to MySQL. This would mean you would need to use port 3306. You’ll need to allow access to your this port from your IP address.

You can check what your IP address is, you can use the https://ip.me.uk site and then allow the IP using DigitalOcean’s console and iptables.

Regards,
KDSys

Submit an Answer