Edit

Share via

Manage Azure Database for MySQL - Flexible Server using the Azure CLI

This article shows you how to manage your Azure Database for MySQL Flexible Server instance deployed in Azure. Management tasks include compute and storage scaling, admin password reset, and viewing server details.

Prerequisites

If you don't have an Azure subscription, create an Azure free account before you begin. Currently, with an Azure free account, you can try Azure Database for MySQL - Flexible Server free for 12 months. For more information, see Use an Azure free account to try Azure Database for MySQL - Flexible Server for free.

This article requires that you're running the Azure CLI version 2.0 or later locally. To see the version installed, run the az --version command. If you need to install or upgrade, see Install Azure CLI.

You need to log in to your account using the az login command. Note the id property, which refers to Subscription ID for your Azure account.

az login

Select the specific subscription under your account using az account set command. Make a note of the id value from the az login output to use as the value for subscription argument in the command. If you have multiple subscriptions, choose the appropriate subscription in which the resource should be billed. To get all your subscription, use az account list.

az account set --subscription <subscription id>

Important

Create a server if none exists.

Scale compute and storage

You can scale up your compute tier, vCores, and storage easily using the following command. For a list of server operations, see az mysql flexible-server update

az mysql flexible-server update --resource-group myresourcegroup --name mydemoserver --sku-name Standard_D4ds_v4 --storage-size 6144
Argument Sample value Description
name mydemoserver Enter a unique name for your Azure Database for MySQL server. The server name can contain only lowercase letters, numbers, and the hyphen (-) character. It must contain from 3 to 63 characters.
resource-group myresourcegroup Provide the name of the Azure resource group.
sku-name Standard_D4ds_v4 Enter the name of the compute tier and size. Follows the convention Standard_{VM size} in shorthand. For more information, see the pricing tiers.
storage-size 6144 The storage capacity of the server (unit is megabytes). Minimum 5,120 and increases in 1,024 increments.

Important

Storage can be scaled up; however, you can't scale storage down.

Manage MySQL databases on a server

You can use any of these commands to create, delete, list, and view database properties of a database on your server

Cmdlet Usage Description
az mysql flexible-server db create az mysql flexible-server db create -g myresourcegroup -s mydemoserver -n mydatabasename Creates a database
az mysql flexible-server db delete az mysql flexible-server db delete -g myresourcegroup -s mydemoserver -n mydatabasename Delete your database from your server. This command doesn't delete your server.
az mysql flexible-server db list az mysql flexible-server db list -g myresourcegroup -s mydemoserver lists all the databases on the server
az mysql flexible-server db show az mysql flexible-server db show -g myresourcegroup -s mydemoserver -n mydatabasename Shows more details of the database

Update admin password

You can change the administrator role's password with this command

az mysql flexible-server update --resource-group myresourcegroup --name mydemoserver --admin-password <new-password>

Important

Make sure password is minimum 8 characters and maximum 128 characters. Password must contain characters from three of the following categories: English uppercase letters, English lowercase letters, numbers, and nonalphanumeric characters.

Delete a server

If you would just like to delete the MySQL Flexible server, you can run az mysql flexible-server server delete command.

az mysql flexible-server delete --resource-group myresourcegroup --name mydemoserver

Related content

  • Last updated on