Unable to connect to DO managed MySQL database - Error 61

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).

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:

1. Test the network connection. Try using 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).
2. Try connecting from a different network. Sometimes, certain networks (like corporate or school networks) may block certain types of traffic. Trying from a different network (like a home network) might help identify if this is the issue.
3. Verify that your database is running. You can check this from your DigitalOcean control panel. If there are any problems like for example the server has run out of disk space, you can try upgrading to a larger instance or also contacting the DigitalOcean support team.

Hope that this helps!

Best,

Bobby