Failed to connect with azure flexible mysql from mysql workbench

Question

Failed to connect with azure flexible mysql from mysql workbench

Administrator DYCN 0

We h User's image

we have enabled the ip firewall also but it is not working.

we have also enable ssl and paste DigiCertGlobalRootG2.crt.pem file on ssl ca too. Previously it was working fine

Pilladi Padma Sai Manisha 5,315 Reputation points Microsoft External Staff Moderator

2026-02-25T13:14:09.9866667+00:00

Hi Administrator DYCN
Thankyou for reaching microsoft Q&A!,

Since the connection was previously working and is now failing even after adding the firewall rule and SSL certificate, this appears to be more related to network reachability or server access configuration rather than authentication. Please first confirm the server connectivity type. If the Flexible Server was recently moved to Private access (VNet Integration), public IP firewall rules will not work and MySQL Workbench from local machines will fail unless the connection is made through a VPN or a jumpbox inside the VNet.

Also verify from the Azure portal that the MySQL Flexible Server state is Running and not Stopped. From your local machine, test DNS and port reachability using telnet dycn-server.mysql.database.azure.com 3306 or Test-NetConnection dycn-server.mysql.database.azure.com -Port 3306. If the test fails, it indicates a network path issue such as NSG, proxy, or routing restriction.

Regarding SSL configuration, for Azure Database for MySQL Flexible Server the SSL Mode in MySQL Workbench should be set to Require, with DigiCertGlobalRootG2.crt.pem added under SSL CA, and client key or certificate fields left empty unless specifically configured. Additionally, ensure the correct public IP is added in the firewall rules or that public access settings have not changed, and confirm no recent modifications were made to Private DNS or networking settings.

If the issue persists, please share the Flexible Server networking type (Public or Private), a screenshot of the Networking blade, and the output of the Test-NetConnection command so we can assist further.
Pilladi Padma Sai Manisha 5,315 Reputation points Microsoft External Staff Moderator

2026-02-27T09:21:30.9733333+00:00

Hi Administrator DYCN
I hope you had a chance to review the information shared earlier, and I hope this information has been helpful! If you still have questions, please let us know what is needed in the comments so the question can be answered.

1 answer

Your answer

Pilladi Padma Sai Manisha 5,315 Reputation points Microsoft External Staff Moderator

2026-02-25T13:14:09.9866667+00:00

Hi Administrator DYCN
Thankyou for reaching microsoft Q&A!,

Since the connection was previously working and is now failing even after adding the firewall rule and SSL certificate, this appears to be more related to network reachability or server access configuration rather than authentication. Please first confirm the server connectivity type. If the Flexible Server was recently moved to Private access (VNet Integration), public IP firewall rules will not work and MySQL Workbench from local machines will fail unless the connection is made through a VPN or a jumpbox inside the VNet.

Also verify from the Azure portal that the MySQL Flexible Server state is Running and not Stopped. From your local machine, test DNS and port reachability using telnet dycn-server.mysql.database.azure.com 3306 or Test-NetConnection dycn-server.mysql.database.azure.com -Port 3306. If the test fails, it indicates a network path issue such as NSG, proxy, or routing restriction.

Regarding SSL configuration, for Azure Database for MySQL Flexible Server the SSL Mode in MySQL Workbench should be set to Require, with DigiCertGlobalRootG2.crt.pem added under SSL CA, and client key or certificate fields left empty unless specifically configured. Additionally, ensure the correct public IP is added in the firewall rules or that public access settings have not changed, and confirm no recent modifications were made to Private DNS or networking settings.

If the issue persists, please share the Flexible Server networking type (Public or Private), a screenshot of the Networking blade, and the output of the Test-NetConnection command so we can assist further.
Pilladi Padma Sai Manisha 5,315 Reputation points Microsoft External Staff Moderator

2026-02-27T09:21:30.9733333+00:00

Hi Administrator DYCN
I hope you had a chance to review the information shared earlier, and I hope this information has been helpful! If you still have questions, please let us know what is needed in the comments so the question can be answered.

Answer 1

Hello , Welcome to MS Q&A

I can suggest some standard fixes you can try if these not help may be need to deep dive specifically to check this in detail

## Quick Fix Checklist

Run through these in order:

- [ ] **Get current public IP** and verify it's in firewall rules
- [ ] **Test connection via Azure Portal Query Editor** (bypasses MySQL Workbench)
- [ ] **Verify server status is "Running"** in Azure Portal
- [ ] **Re-download SSL certificate** and update path in MySQL Workbench
- [ ] **Set SSL Mode to "REQUIRED"** (not PREFERRED or DISABLED)
- [ ] **Test network connectivity** to port 3306
- [ ] **Try connecting from different network** (mobile hotspot)
- [ ] **Check MySQL Workbench error message** - look for specific error code
- [ ] **Verify password hasn't expired** or been changed
- [ ] **Check Azure MySQL server logs** for connection attempts

Pls check and let us know

Thanks
Deepanshu

Share via

Failed to connect with azure flexible mysql from mysql workbench

1 answer

Your answer