Connecting to a PlanetScale MySQL db with DBeaver on a Mac

Nov 2023

tags:planetscale

I'm currently using DBeaver Community Edition to mess with my live database, as any good developer should do.

It took me a minute to figure out how to connect to my PlanetScale db with it, as I was seeing the following rather unhelpful error message when trying to connect with SSL:

A connection error reading "the trustAnchors parameter must be non-empty"

What this means, obviously, is that you need to head back over to the SSL tab and enter the path to your root certificate, which on MacOS is /etc/ssl/cert.pem.

Enter /etc/ssl/cert.pem in the CA Certificate field

With that, it should connect. Good luck.