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
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!
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.
Click below to sign up and get $200 of credit to try our products over 60 days!
Enter your email to get $200 in credit for your first 60 days with DigitalOcean.
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.