Symptoms
When checking the SSL variable in MySQL the above error is received.
Description
When running the following command:
mysql -e "show variables like '% ssl%';"You will get the error:
ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1)This is gotten due to the common name matching the name used in the CA certificate
Workaround
The server/client certificate will need to be regenerated using a different common name then what was used for the CA certificate.
The following documentation shows ho this can be completed:
https://docs.cpanel.net/knowledge-base/security/how-to-configure-mysql-ssl-connections/