I have connected to a DO managed MySQL database for months. Starting on 8/1/2023 the connection stopped working.
I used this DO tutorial to create the connection: https://docs.digitalocean.com/products/databases/mysql/how-to/connect/#connect-to-the-database
I have confirmed that:
I have tried connecting using MySQL Workbench, PyCharm, and mysql CLI.
Is anyone else experiencing this issue? Anyone have any ideas on troubleshooting?
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!
Hi there,
I’ve just checked the DigitalOcean status page and there have been no reported incidents that might have caused the problem for the past few days.
Error 61 usually signifies that the connection was actively refused, which may occur if your home IP address has changed and you would have to add your new IP address to the trusted sources of your database cluster.
You can follow the steps on how to do that here:
https://docs.digitalocean.com/products/databases/mysql/how-to/secure/
If this does not help there are a few other things that I could suggest:
telnet or nc (netcat) to test the connection to your database host and port. This can help you identify if the problem lies with the network connection itself. For example, you can use the command telnet your-db-host 3306 (replace ‘your-db-host’ and ‘3306’ with your actual DB host and port).Hope that this helps!
Best,
Bobby
Follow up on my original question:
I tested the connection on a different network and was able to connect to the database indicating that this may be an issue with the network I was on.
HOWEVER…I had the IP of my home network (the one that wasn’t working) white listed on Digital Ocean and verified that there are no firewalls on the network or my computer.
I tried connecting yesterday and could not. I tried connecting this morning and it worked! Same IP address, same computer and network settings. I didn’t change anything. Seems like this could have been a Digital Ocean bug or a bug with the WIFI router software (Eero).
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.