Unable to connect to MySQL database with DataGrip & MySQL Workbench

Hey there, I made a new Free plan and I’ve chosen MySQL as a database, I followed the instructions on how to connect to the database but no luck, I enabled SSL and Included the CA file in both MySQL Workbench & DataGrip and no luck. I have the default IP filter which allows everyone to connect (supposedly)

As for DataGrip:

Since I am a new User I can’t send multiple Images

The error message “unable to connect to database server” suggests a failure in establishing a connection to the MySQL server. Troubleshoot by verifying connection parameters, ensuring MySQL server is running, checking for firewall/network issues, confirming user permissions, and restarting the server if necessary. If problems persist, contact Aiven support for assistance.

Best Regard
Danish Hafeez | QA Assistant
ICTInnovations

MySQL server ? its your server I don’t need to install MySQL server… I only need the driver since I am using the server you provide. I connected before to another MySQL database and it connected fine (external - non local)

I don’t think the firewall is the issue but If you can help show me how to configure my firewall.

Hmmm. I’m able to connect ok from MySQL Workbench here, just copy/pasta-ing the values from the Service Overview in Aiven’s Console:

Same thing with DataGrip:


^ Does your config page look basically the same?

Since the answer to that appears to be “yes” from what I can see… second question is at the very bottom of your Service Overview page in Aiven Console, can you confirm “Allowed IP addresses” set to 0.0.0.0/0? (You say “supposedly,” but not sure exactly what that means :slight_smile: ) Because if not, that could definitely be a source of issues:

The only other thing I can think of is if you randomly hit a fluke where Free Tier was down for maintenance or so. https://status.aiven.io/ is a good place to bookmark just in case.

“supposedly” what I meant is that it is supposed to happen (since don’t know the exact cause at the time). now everything works fine for some reason, I think its because of the maintenance as you said.

1 Like

Fantastic, thanks for reporting back! Sorry you hit an initial issue, but glad to hear it’s working well now. :sunglasses:

It’s great to hear that the connection issue was resolved! For anyone facing similar problems, double-checking firewall settings, IP address permissions, and SSL configurations can often help. Keeping an eye on service status pages like Aiven’s can also provide timely updates. If issues persist, reaching out to support can offer more personalized assistance. Much like how TraceShipments meticulously tracks every step of a shipment to ensure smooth delivery, careful attention to each detail in your database setup can prevent connectivity problems.