Does my client need to use the CA certificate to connect to the managed MySQL databases?

November 5, 2019 113 views
DigitalOcean Managed MySQL Database

Hi! I am trying to use a managed MySQL database with my Rails app. I thought that I had to have the client use the CA certificate that I can download from the DO control panel for the MySQL cluster, but if I specify that I get the error SSL_CTX_set_default_verify_paths failed. If I don’t specify the certificate, I can connect to the database. Since ssl_mode is still set to required in the connection string, can I rest assured that the connection between the database and the clients is encrypted?

Thanks in advance

Be the first one to answer this question.