Azure MySQL SSL-mode requird

[alanyu0762]

Hi,

When we try to use Azure mysql as the storage for dtm and we are facing the follow error

ERROR 3159 (HY000): Connections using insecure transport are prohibited while --require_secure_transport=ON.

Based on our knowledge, Azure MySQL necessitates an SSL-mode in the connection, along with a specific SSL CA.

你好,

当我们尝试将Azure MySQL用作dtm的存储时，我们遇到了以下错误：

ERROR 3159 (HY000): Connections using insecure transport are prohibited while --require_secure_transport=ON.

根据我们的了解，Azure MySQL在连接时需要使用SSL模式，并且需要特定的SSL CA。

Ref: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-connect-tls-ssl

The following example shows how to connect to your server using the mysql command-line interface. Use the --ssl-mode=REQUIRED connection string setting to enforce TLS/SSL certificate verification. Pass the local certificate file path to the --ssl-ca parameter. Replace values with your actual server name and password.

sudo apt-get install mysql-client
wget --no-check-certificate https://dl.cacerts.digicert.com/DigiCertGlobalRootCA.crt.pem
mysql -h mydemoserver.mysql.database.azure.com -u mydemouser -p --ssl-mode=REQUIRED --ssl-ca=DigiCertGlobalRootCA.crt.pem