Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Why can I access my database via ssh and phpmyadmin but not mysql workbench? Question Question
Allow all IP to access my Secured PhpmyAdmin Question Question

Question

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

Posted April 19, 2020 1.6k 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.

Add a comment
noahmcdonough
By:
noahmcdonough

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Why can I access my database via ssh and phpmyadmin but not mysql workbench? Question Question
Allow all IP to access my Secured PhpmyAdmin Question Question

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.

×
Submit an Answer
1 answer
KFSys April 19, 2020

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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help