Question

Can not connect to database server MySql Workbench

I am having issues when I add trusted source to connect to mysql database cluster I am using MySQL Workbench to connect to the server but every time I am getting this error:

Your connection attempt failed for user ‘*******************’ to the MySQL server at *******************************:: Unable to connect to localhost

Please: 1 Check that MySQL is running on address ************-0.b.db.ondigitalocean.com 2 Check that MySQL is reachable on port 25060 (note: 3306 is the default, but this can be changed) 3 Check the user ******************** has rights to connect to ******************0.b.db.ondigitalocean.com from your address (MySQL rights define what clients can connect to the server and from which machines) 4 Make sure you are both providing a password if needed and using the correct password for *****************************-0.b.db.ondigitalocean.com connecting from the host address you’re connecting from.

I have followed this tutorial as well and did same steps but getting same error

MySql client version is. 8+ and all connection details are correct. when i make connect open to all it work fine. note that my web application and database cluster are in same region as well as I have added my computer ip to trusted sources but still no success.


Submit an answer

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!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Hi @moopointbiz,

Please ensure you are whitelisting a correct IP address in the database trusted source list. You can reach out to DigitalOcean support for assistance on this.

Regards, Anadi