Access Azure App Service Database from local machine

Question

I'm trying to access Azure App Service Database (Postgress)from a client tool install in my local machine. But still I could not figure-out how to do this.

Can some one please help on this ?

Thanks.

Answer 1

ERROR 2005 (HY000): Unknown MySQL server host '******'

This error indicates you are using mysql database and not postgreSQL and this error can be related to a firewall issue.

Create a firewall rule and add a Public IP address as follows:

• Go to the networking tab and check Allow public access to this resource through the internet using a public IP address. Add the Client IP address to the firewall as shown below:

After creating the firewall rule, try to connect to the server; it should connect successfully.

If you are using VNET instead of public access, create a Virtual Machine in the VNET and try to connect the server in the VM.

For more information, you can refer to this answer in MS Q/A platform.