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

Leugzim Rullani 0 Reputation points
2024-06-24T12:57:42.1366667+00:00

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?

Azure SQL Database
Microsoft Intune MacOs
Microsoft Intune MacOs
Microsoft Intune: A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.MacOs: A family of Apple operating systems for the Apple Mac line of computers.
88 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.