You are viewing this site over HTTP, which is not secure. Please consider switching to HTTPS instead.

Connect to a MySql In App database in Azure successfully

Sunday, April 17, 2022

TL;DR: The default connection string provided by Azure MySQL In App is unusable from .NET. Save yourself some time and convert it before use.

For a while now, Azure supports "MySQL in App" for App Services. In a nutshell, it's a free MySQL instance with some limitations, but very usable for small sites. Setting it up is simple: enable it by setting a switch to On and Azure does the rest. You even get a phpAdmin-instance to configure your server! Sounds like a good deal. More information here.

To help you connect to this free MySQL instance, Azure defines an environment variable called MYSQLCONNSTR_localdb that you're supposed to be able to use. Spoiler: it's not.

The connection string set in MYSQLCONNSTR_localdb has the following format:

Database=localdb;Server=127.0.0.1:49321;User Id=azure;Password=some_password

If you try to Open() a MySqlConnection using this connection string will get an error message "No such host". I tried for hours to change my code to get it to work but it won't ever. The correct connection string is:

Server=127.0.0.1;Port=49321;Database=localdb;Uid=azure;Pwd=some_password

In other words:

  1. Don't use Data Source=, but Server=
  2. Split the port number (here: 49312) and the colon off into Port=
  3. Change User= Id into Uid=

Maybe only some of these steps are absolutely necessary, but this particular transformation works for me ;-)

You're welcome.