How to disable SSL on MySQL Flexible Server

Question

I'm trying to access my MySQL flexible server. I created it like this:

• I logged into the Azure Portal.
• I selected "App Services"
• I selected "Create" and "Web App + Database"
• For Runtime stack, I chose PHP 8.2
• For Engine, I chose MySQL - Flexible Server
• For Hosting, I chose Basic

The first step is to configure network access to my MySQL database. I don't want to pay for a VM, so I turned off the require_secure_transport server parameter, but the networking settings haven't changed. I restarted the server too, but TLS/SSL is still enforced. How do I disable SSL?

I found this line:

"If you need to disable SSL, visit the Azure portal and select the Connection security page to disable the Enforce SSL connection toggle button."

But as far as I can tell, neither the connection security page nor the enforce SSL connection toggle button exist.

Answer 1

Hi Tim Zuspan • ,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want to know how to disable SSL on Azure MySQL Flexible Server.

If your client application doesn't support encrypted connections, you need to disable encrypted connections enforcement on your flexible server. To disable encrypted connections enforcement, you need to set require_secure_transport server parameter to OFF as shown in the screenshot, and save the server parameter configuration for it to take effect. require_secure_transport is a dynamic server parameter which takes effect immediately and doesn't require server restart to take effect.

Please share screenshot of the page where you could not find the settings to disable.

Thanks