How to resolve the SSL connection error when connecting to Azure MySQL from MacOS?

Question

I am attempting to connect to my Azure MySQL database from my MacOS system using SSL, but I am encountering persistent issues. Despite following the instructions for setting up SSL, I receive the following error message:
ERROR 2026 (HY000): SSL connection error: SSL_CTX_set_default_verify_paths failed

Here’s what I’ve done so far:

• Downloaded the SSL certificates and placed them in a folder on my desktop.
• Used the following command to attempt the connection:

mysql -h meinsportdatenserver.mysql.database.azure.com -u adminLeo -p --ssl-ca=/Users/Zeqiri/Desktop/zertis/DigiCertGlobalRootCA.pem

Ensured the permissions for the certificate files are set correctly using:
chmod 644 /Users/Zeqiri/Desktop/zertis/DigiCertGlobalRootCA.pem

erified the certificate is in PEM format.

Despite these steps, I still receive the SSL connection error. How can I troubleshoot and resolve this issue to successfully connect to my Azure MySQL database using SSL on MacOS?

Additional Information:

• I have confirmed that the certificate file paths are correct and the files are accessible.
• I am using the MySQL command-line client to attempt the connection.
• I have also tried connecting without SSL, which worked, but I need to secure the connection using SSL.

What could be causing this error, and how can I fix it to establish a secure connection to my Azure MySQL database?