How to Connect with Managed Identity to Azure Database for MySQL Flexible Server

Question

I have web app service in Azure written in PHP. I also have database which is Azure Database for MySQL Flexible Server.

I have enabled AD authentication in MySQL flexible server. I have also enabled user/system managed identity in the Web app service.

How to connect the MySQL flexible Server using managed identity, could you please shared the approach and documentation if any. I have tried my best to find it. Any help would be appreciated.

Answer 1

Hi Anbu,

The normal pattern is to make HTTP GET request to the local token service from your code running on App Services. The response will give you the token you need to connect to the service (in this case Azure Database for MySQL Flexible Server). Please see article below:

https://learn.microsoft.com/en-us/azure/app-service/overview-managed-identity?tabs=portal%2Chttp#connect-to-azure-services-in-app-code

Based on what is written in below article you would use the access token you retrieved above as the password when connecting to the database:

https://learn.microsoft.com/en-us/azure/mysql/single-server/how-to-connect-with-managed-identity#connecting-using-managed-identity-in-c

Please click Accept Answer if the above was helpful. If something I wrote above is unclear or you need additional assistance please add a comment below.

Thanks.

-TP

Answer 2

Hi, @Sekar, Anbu We do not have documentation specific to PHP using managed identity however you can use the same idea that we have written in .net code

https://techcommunity.microsoft.com/t5/azure-database-for-mysql-blog/how-to-connect-to-azure-database-for-mysql-using-managed/ba-p/1518196

I hope this should help.

Please let me know if you have any questions on the above blog.

Regards

Geetha