Best way to connect Azure Database for MySQL flexible server with private access

Question

We have been enabling public access in Azure Database for MySQL flexible server for viewing and editing data from workbench from our local machines (remote machines). As a security requirement of clients, we are planning to switch to private access in the MySQL flexible server.

We are small company without dedicated on-premise network (we have been working from home personal networks). What is the best way to connect to Azure database for MySQL flexible server with private access and still being able to connect and edit data using workbench with minimal effort?

Security is our concern, at the same time, we don't have on-premise network to be able to use ExpressRoute, or VPN.

Any suggestions will be appreciated.

Answer 1

Hi Bikash •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want to switch to private access in the MySQL flexible server.

Follow the steps below:

1. On the MySQL flexible server page, under Settings, select Networking.
2. To disable public access on the MySQL flexible server, uncheck Allow public access to this resource through the internet using a public IP address under Public access.

Select Save to save the changes.

A notification will confirm that the connection security setting was successfully enabled.

Note:

The MySQL flexible server must have been deployed with Public access (allowed IP addresses) and Private endpoint as the connectivity method to implement this.

Reference Link: Deny Public Network Access in Azure Database for MySQL - Flexible Server using Azure portal

If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

Thank you.