ConnectionStrings in appsettings.json with ssl? Net Core

Question

How do i connect api to azure mysql database.

Maybe need to change this

"MySqlDbConnectionX": "Server = mydb.mysql.database.azure.com; Database = db; User Id = id; Password = password;"

for this

"MySqlDbConnectionX": Server = "mydb.mysql.database.azure.com"; UserID = "id"; Password = "{your_password}"; Database = "{your_database}"; SslMode = MySqlSslMode.Required; SslCa = "{path_to_CA_cert}"

I would need to know the path to cert, but I don't know where to put it.

If anyone has an example, please send me.

please explain the reason for the unlike so i can fix the question. — MATCH, Dec 07 '21 at 17:43

score 1 · Accepted Answer · answered Dec 08 '21 at 02:16

From your description, we can clearly know that you are using Azure DataBase for Mysql.

By default, Azure Database for MySQL enforces SSL connections between your server and your client applications to protect against MITM (man in the middle) attacks. This is done to make the connection to your server as secure as possible.

From Shantanu's answer , we can clear know we don't need to add SslMode = MySqlSslMode.Required; SslCa = "{path_to_CA_cert}" in our connectionstring.

And I also read some description about the Client Certificate and Key for Azure Database for MySQL.

This is not possible to store a CA certificate on the MySQL server when using the hosted Azure MySQL instance.

So if you want enable ssl, you can copy and use the connection string from azure portal directly.

ConnectionStrings in appsettings.json with ssl? Net Core

1 Answers1