Retrieve correct information about publicNetworkAccess for Azure MySQL flexible server

Question

Hi! I'm using the rest api to retrieve information abot Azure Database for MySQL flexible server.

In particular, I'm using this endpoint to list all the servers: https://learn.microsoft.com/en-us/rest/api/mysql/flexibleserver/servers/list?view=rest-mysql-flexibleserver-2023-12-30&tabs=HTTP

The issue is that everytime if fetch any server the property publicNetworkAccess has a value of 'Enabled', even if i have disabled public access and I have a private network attached to the server (as shown in the attached image).

The same thing with my PostgresSQL servers works correcly, everytime i disabled the check, the rest api starts answering with 'Disabled'.

Is this a bug? Am I missing something? What is the correct meaning for the publicNetworkAccess property in a MySQL Flexible Server?

Thank you!

Answer 1

Hello Gonzalo Avalos Ribas,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Regarding your questions:

Is this a bug?

Since the same configuration works correctly for your PostgreSQL servers. It's advisable to report this issue to Azure support via Azure Portal for further investigation. It might be a bug.

Am I missing something?

Check your server's network settings and double-check that the public access is indeed disabled and that the private network is properly attached.

What is the correct meaning for the publicNetworkAccess property in a MySQL Flexible Server?

The publicNetworkAccess property indicates whether the server is accessible through a public endpoint. When set to 'Enabled', it means the server can be accessed via the internet, using a publicly resolvable DNS address and if you disabled public access and attached a private network, this property should ideally reflect 'Disabled'.

Read more information about second and the last question in this link: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-public

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.