Only One Computer Can not connect to Azure MySql Flexible Server

Question

Developed a windows application connected to Azure MySQL flexible server; all users of this application can connect to Azure MySQL flexible server through the application and they are allocated in one country. only one user who is allocated out that country could connect one time and never later.

• The IP is mentioned in the Firewall rule
• The Server name , User Name , Password Correct 100%
• That user use TLS 1.2 (Already checked in their computer)

The question is : how can we solve this problem and make that computer connected again to the AZURE MySQL Flexible Server

Answer 1

Hi @Tarek El Hajj Moussa,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

We would like to inform you that, connection problems might be caused by a variety of things, including:

• Firewall settings
• Connection time-out
• Incorrect login information
• Maximum limit reached on some Azure Database for MySQL flexible server resources.

Troubleshoot common errors:

If the application persistently fails to connect to Azure Database for MySQL flexible server, it usually indicates an issue with one of the following:

• Encrypted connection using TLS/SSL: Azure Database for MySQL flexible server supports encrypted connections using Transport Layer Security (TLS 1.2) and all incoming connections with TLS 1.0 and TLS 1.1 will be denied by default. You can disable enforcement of encrypted connections or change the TLS version. Learn more about Encrypted connectivity using Transport Layer Security (TLS 1.2) in Azure Database for MySQL flexible server.
• Azure Database for MySQL flexible server in Private access (VNet Integration): Make sure you are connecting from within the same virtual network as the Azure Database for MySQL flexible server instance. Refer to [virtual network in Azure Database for MySQL flexible server]
• Azure Database for MySQL flexible server with Public access (allowed IP addresses), make sure that the firewall is configured to allow connections from your client. Refer to Create and manage Azure Database for MySQL flexible server firewall rules using the Azure portal.
• Client firewall configuration: The firewall on your client must allow connections to your Azure Database for MySQL flexible server instance. IP addresses and ports of the server that you connect to must be allowed as well as application names such as MySQL in some firewalls.
• User error: You might have mistyped connection parameters, such as the server name in the connection string.

Resolve connectivity issues by following below mentioned steps:

• Refer to encrypted connectivity using Transport Layer Security (TLS 1.2) in Azure Database for MySQL flexible server --> to learn more about encrypted connections.
• If you are using Public access (allowed IP addresses), then set up firewall rules to allow the client IP address. For temporary testing purposes only, set up a firewall rule using 0.0.0.0 as the starting IP address and using 255.255.255.255 as the ending IP address. This will open the server to all IP addresses. If this resolves your connectivity issue, remove this rule and create a firewall rule for an appropriately limited IP address or address range.
• On all firewalls between the client and the internet, make sure that port 3306 is open for outbound connections.
• Verify your connection string and other connection settings. Refer to the pre-defined connection strings in the Connection Strings page available for your server in the Azure portal for common languages.

Please refer to the below mentioned links for more information.

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-connection-issues

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-errors#common-connection-errors

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-connectivity-issues?source=recommendations

If this does not help, any screenshots or additional information would be greatly appreciated, as it will help us conduct a more thorough investigation.

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.