Azure MySQL Firewall Configuration

Managing Firewall Rules with Azure CLI

Azure CLI provides a powerful and flexible way to manage network security for your Azure Database for MySQL server, including configuring firewall rules.

Prerequisites

• An Azure account with an active subscription.
• An Azure Database for MySQL server created in your subscription.
• Azure CLI installed and logged in to your account. If not installed, you can find instructions here.

Viewing Existing Firewall Rules

You can list all existing firewall rules for your MySQL server using the following command:

Creating a New Firewall Rule

To allow access from a specific IP address or a range of IP addresses, you can create a new firewall rule. This is crucial for restricting access to your database.

Allowing a Single IP Address

This command allows access from the specified start IP address to your server.

Example:

Allowing an IP Address Range

Specify a start and end IP address to define a range for which access will be permitted.

Example:

Allowing All Azure Services

To allow all Azure services to connect to your server, use the following command:

Updating a Firewall Rule

You can modify an existing firewall rule by updating its IP address range.

Deleting a Firewall Rule

To remove a firewall rule, use the delete command. This is useful for revoking access that is no longer needed.

Example:

Explore Full Azure CLI Documentation