Azure Database for MySQL – Manage

Azure / Databases / MySQL / Manage

How‑to manage Azure Database for MySQL

This guide walks you through common management tasks for an Azure Database for MySQL server, including firewall rules, configuration parameters, backups, and deletion.

1️⃣ Configure firewall rules

Allow your client IP addresses to connect to the MySQL server.

az mysql server firewall-rule create \
    --resource-group MyResourceGroup \
    --server mymysqlserver \
    --name AllowMyIP \
    --start-ip-address 203.0.113.5 \
    --end-ip-address 203.0.113.5

Azure CLI docs

2️⃣ Update server parameters

Change the slow_query_log and long_query_time settings.

az mysql server configuration set \
    --resource-group MyResourceGroup \
    --server mymysqlserver \
    --name slow_query_log \
    --value ON

az mysql server configuration set \
    --resource-group MyResourceGroup \
    --server mymysqlserver \
    --name long_query_time \
    --value 2

Configuring server parameters

3️⃣ Manage backups & restore

Azure automatically creates backups. To restore to a new server:

az mysql server restore \
    --resource-group MyResourceGroup \
    --name mynewserver \
    --source-server mymysqlserver \
    --restore-point-in-time "2024-07-01T12:00:00Z"

Backup and restore guide

4️⃣ Delete a MySQL server

When a server is no longer needed, you can delete it. This operation is irreversible.

az mysql server delete \
    --resource-group MyResourceGroup \
    --name mymysqlserver \
    --yes

Delete server documentation