Question
Unable to connect to MySql Server remotely
- Posted on August 30, 2022
- DigitalOcean Managed MySQL Database
Asked by BubblyTurquoiseWalrus
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.
Hollie's Hub for Good
Working on improving health and education, reducing inequality, and spurring economic growth? We’d like to help.
Get started for free
Enter your email to get $200 in credit for your first 60 days with DigitalOcean.
New accounts only. By submitting your email you agree to our Privacy Policy.
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.