Unable to establish SSL connection to MySQL server

Question

I am trying to connect to a MySQL server over SSL, however am getting the error:

Unable to establish SSL connection

Steps taken:

1. In MySQL Workbench, used the SSL Wizard to certificates and keys.
2. Uploaded ca-cert.pem, server-cert.pem, and server-key.pem to the server.

3. In my.cnf on the server, added the following:

   [mysqld] ssl-ca=/path/to/ca-cert.pem ssl-cert=/path/to/server-cert.pem ssl-key=/path/to/server-key.pem

4. Restarted MySQL service on the server.

5. Back in MySQL Workbench, set the connection to require SSL and use the files ca-cert.pem, client-cert.pem, and client-key.pem stored in my local computer.

6. Tested the connection in Workbench, got the 'Unable to establish SSL connection' error.

I have also noticed that running show global variables like 'have_%ssl'; shows that have_ssl is disabled.