Question

Unable to connect to MySql Server remotely

I have a MySql server setup under the managed databases. I’m not able to connect to it remotely using MySQL Workbench 8.0. I’ve tried using the doadmin user as well as the user I created back when the server was first created. The server has been upgraded to Version 8 since then, so I created a new user just to make sure it wasn’t an issue with that.

No matter what user I use or configuration I enter, I always get the same error “Failed to Connect to MySQL at <host>:25060 with user <username> Unable to connect to localhost”.

I have tried the following configurations (with all 3 users):

Standard (TCP/IP) - SSL = No Standard (TCP/IP) - SSL = If available Standard (TCP/IP) - SSL = Require Standard (TCP/IP) - SSL = Require and Verify CA (used downloaded CA file from control panel)

I also tried using the Standard TCP/IP over SSH using my personal SSH key, but as expected authentication failed (I would have been concerned it this WOULD have worked, TBH).

I’m not seeing any errors in my apps which access the MySQL server from within the DO network, so I have a feeling this is a configuration issue on my side. I have added my IP Address to the Trusted Sources list


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.

I found the problem. I booted up my mac (which had been working fine) and attempted to connect and it failed. That lead me towards connectivity, so I tried multiple different endpoints on my VPN to make sure it wasn’t a connection quality issue. I also disconnected my VPN and I was able to connect. Apparently, DO blocks connections from hosts that are going through Express VPN.