I have been trying to connect to Azure MySQL database via MySQL Workbench v8 by following this document.
Although I am able to connect to the MySQL server via command line, the same connection via MySQL Workbench does not succeed. It throws an error: SSL Connection Error: Unable to get certificate.
Can somebody tell what am I doing wrong with MySQL Workbench?
I figured out the solution. Download BaltimoreCyberTrustRoot.crt.pem from this link and include this certificate in SSL-CA file path and set useSSL field to "Require" in MySql workbench. Keep other fields empty.
Check this screenshot for the configuration.
