Getting MySQL working with self-signed SSL certificates is pretty simple. Having it working with a certificate signed by a trusted authority is also very simple, we just need to set the correct path and privileges to the file. The problem comes when we need to make MySQL validate the certificate signature against the authority public [&]

https://www.percona.com/blog/2020/12/04/how-to-configure-mysql-ssl-with-public-certificates/