mysql - “Client from Interface Endpoint is not allowed to access the server. Please make sure your Virtual Network is correctly configured. (SQL state 28000)

Question

I'm trying to connect an application in Azure to my Azure DB for MySQL. I have created a private endpoint to it which was approved. However, while trying to connect to the DB, their team is getting the following error:

Client from Interface Endpoint is not allowed to access the server. Please make sure your Virtual Network is correctly configured. (SQL state 28000)

Could you help me understand what this error means? I can't find anything similar on the internet.

Points to be noted:

1. We have to Deny Public Network Access so "Allow Access to Azure services" is not an option to follow.
2. All connections to the database have to go through the Private endpoint.

question from:https://stackoverflow.com/questions/65880163/client-from-interface-endpoint-is-not-allowed-to-access-the-server-please-make

Answer 1

Have you added the Client IP in Network Firewall.

If you disable allow access to all Azure resources then you will have to explicitly add the IP of user who will be accessing the Azure DB.

In the Azure DB, you will see following options, you need to select firewall option and then add firewall so that that particular IP can be bypassed.

More details can be found here