Cannot connect to new MySQL database from workbench

Posted April 19, 2020 894 views

I just created a new database cluster connected to a droplet running ubuntu. I have all the connection details, but when I try to connect with Workbench, I get SSL errors.
I am connecting with standard tcp method, host, port, user, pass ect.
Then under SSL I have it useSSL - require and I have tried using the ca-cert every way possible no success, using the ca-cert in the ‘SSL CA cert’, 'SSL Key file’ and 'SSL cert file’… various SSL errors.
Saw someone say you gotta convert to a pem, tried that same as above, no dice.
Saw a bunch of things saying you have to have this exact version of workbench, tried that… no.
This seriously should not be this hard so I guess I’m missing something obvious. Any help would be nice, or any other info I need to provide

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

I guess I solved this on my own… it works without using the cert in any capacity… what is the cert for

  • Thanks for this – I spent over an hour trying to get this to work as well, and other answers stated the CA Cert was necessary… just completely dropped trying to set SSL at all, and now it works fine.

    What’s even the point of the cert? I guess it’s a bit above my head, or something, because it appears to be totally unnecessary…