About the connection problems and troubleshooting methods encountered in daily use of Azure MySQL, azuremysql
Due to firewall problems, TCP keep alive problems, and MySQL parameter problems, these three problems are common in use. So today I will share my troubleshooting methods.
Let's talk about firewall problems today.
Most people try to connect after creating a MySQL database on Azure instance for the first time. However, the result is not a successful connection, but an error message as shown in:
This error message indicates that your IP address is not within the access range of the MySQL on Azure firewall. This setting can prevent the production users who set simple passwords from being maliciously dictionary attacked to some extent, of course, Azure also has other measures to prevent Rescue Methods After malicious intrusion, but this is not discussed in this article.
Now that the firewall has disabled your access requests, add the Client IP address to the allow list in the firewall.
First, open the MySQL database on the Azure portal and click"Connection Security", The right pane appears"Add ClientIP.
ClickAdd ClientIPEnter the name (custom) of your firewall's access IP list, IP start address, and IP end address.
Enter the current IP address and click Save. Wait a moment to start your journey to MySQL Azure.
Note
Avoid setting the IP range to 0.0.0.0-255.255.255.255.255, which means that the Azure firewall is invalid.
If you want to help your friends who encounter the same problem in Azure, click here to view the picture if you cannot see it.