Azure Database for MySQL CLI Reference

Overview

The Azure CLI extension azure-cli-mysql provides commands to manage Azure Database for MySQL servers, databases, configurations, and more. It integrates with the standard az command-line tool.

Install the CLI

az extension add --name mysql

Verify installation:

az mysql --help

Command Reference

Command	Description
`az mysql server create`	Create a new MySQL server.
`az mysql server delete`	Delete an existing MySQL server.
`az mysql db create`	Create a database on a server.
`az mysql db delete`	Delete a database.
`az mysql server firewall-rule create`	Configure firewall rules.
`az mysql server config list`	List server configurations.
`az mysql server config set`	Update a server configuration.
`az mysql flexible-server create`	Create a MySQL Flexible Server.
`az mysql flexible-server firewall-rule create`	Set firewall rules for Flexible Server.

For a full list, run az mysql -h.

Usage Examples

Create a MySQL Server

az mysql server create \
  --resource-group MyResourceGroup \
  --name mymysqlserver \
  --location eastus \
  --admin-user myadmin \
  --admin-password MyP@ssw0rd \
  --sku-name GP_Gen5_2

Configure a Firewall Rule

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

Create a Database

az mysql db create \
  --resource-group MyResourceGroup \
  --server-name mymysqlserver \
  --name mydatabase

Set a Server Configuration

az mysql server config set \
  --resource-group MyResourceGroup \
  --server-name mymysqlserver \
  --name max_connections \
  --value 200