Unable to connect to DO managed MySQL database - Error 61

Question

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 am using the CA certificate with the setting to “require and verify CA”
I have not reached a connection thread limit (5 out of 150 in use)
My IP address is white listed
The firewall on my Mac is turned off and I am not using a VPN

I have tried connecting using MySQL Workbench, PyCharm, and mysql CLI.

Is anyone else experiencing this issue? Anyone have any ideas on troubleshooting?

Bobby · Answer

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

9cab9417a3d4439398f3f64f81a39b · Answer

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

Become a contributor for community

DigitalOcean Documentation

Resources for startups and AI-native businesses

The developer cloud

Start building today

Report this

Unable to connect to DO managed MySQL database - Error 61

Related questions

Mysql Data disappears intermittently

Droplet: Docker => laravel (mysql) + astro app [unusable]

docker laravel app with astro frontend

Can I create a managed MySQL cluster running a recent version?

how to connect digital ocean app platform app with cpanel mysql database?

What’s the best way to handle downtime during software deployments?

Where to Find Slow Query Logs in Managed Database (Already Enabled)?

Search index command in pimcore 10.5.15 production gives error.

Query taking 1 minute to run

Fullstack Architecture Deployments Recomendations

Mysql CPU alerts and max_execution_time

I can't install MySQL on the server

Report this

Unable to connect to DO managed MySQL database - Error 61

Related questions

Mysql Data disappears intermittently

Droplet: Docker => laravel (mysql) + astro app [unusable]

docker laravel app with astro frontend

Can I create a managed MySQL cluster running a recent version?

how to connect digital ocean app platform app with cpanel mysql database?

What’s the best way to handle downtime during software deployments?

Where to Find Slow Query Logs in Managed Database (Already Enabled)?

Search index command in pimcore 10.5.15 production gives error.

Query taking 1 minute to run

Fullstack Architecture Deployments Recomendations

Mysql CPU alerts and max_execution_time

I can't install MySQL on the server