Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
713 questions
How do I fix this error? MySql.Data.MySqlClient.MySqlException: 'Unable to connect to any of the specified MySQL hosts.'
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 68%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Junior
0
Reputation points
I made an asp.net api that is currently hosted on azure webapp. I am having trouble with the post put and delete request so I tried running the code I have locally, but I keep getting this error "MySql.Data.MySqlClient.MySqlException: 'Unable to connect to any of the specified MySQL hosts.'" Initially, it was working before, but now that I want to run the app locally and make crud operations to a mysql database also hosted on azure mysql server, I get that error. Now that I think about it, it probably is a server error. I say this because the only calls that work online are the get calls but when I try perform post, put or delete, it does not work. where as when I try to work on it locally, none of my endpoints work
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee2023-05-16T09:49:50.3433333+00:00 Hi
Junior •,Welcome to Microsoft Q&A forum.
As I understand, you are getting error MySql.Data.MySqlClient.MySqlException: 'Unable to connect to any of the specified MySQL hosts. when trying to connect to Azure Database for MySQL.
Could you please let us know the configuration details of the Database(Single/Flexible, Region, Compute/Storage etc).
Also, please try to connect to the server and let us know what error appears here:
If you see the following error message while connecting to your flexible server following the command earlier, you missed setting the firewall rule using the "Allow public access from any Azure service within Azure to this server" mentioned earlier or the option isn't saved. Please retry setting firewall and try again. ERROR 2002 (HY000): Can't connect to MySQL server on <servername> (115)
Also, check if some vpn client is running, disable and retry. Check Firewall settings too.
Please share details and screenshot of the error. Thank you.
-
ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee
2023-05-17T09:29:36.3033333+00:00 Hi
Junior •,Just checking if you got a chance to look at the previous comment, thanks.
Sign in to comment