Configure MySQL with letsencrypt


#1

My domain is: seibercom.net
My web server is (include version): Apache/2.4.37 (FreeBSD)
The operating system my web server runs on is (include version): FreeBSD 11.2-RELEASE-p4
I can login to a root shell on my machine (yes or no, or I don’t know): YES
I’m using a control panel to manage my site (no, or provide the name and version of the control panel): no

I am trying to configure a MySQL server & client, version: 8.0.12 for SSL. MySQL is rejecting the certificates. I need both server and client certificates. The “my.cnf” file contains this:
[client]
#ssl-ca =
#ssl-cert =
#ssl-key =

[mysqld]
#ssl-ca =
#ssl-cert =
#ssl-key =

I am not sure which keys go where. I have tried different combinations, but they all fail.

Thanks!


#2

Hi,

For my personal setup, i use the Let’s Encrypt certificate at the [mysqld] area… (to identify server identity)

https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html

If you do not wish to force clients to present a client certificate, left the [client] empty.

Thank you