az mysql flexible-server

Команды

Имя	Описание	Тип	Состояние
az mysql flexible-server ad-admin	Manage server Active Directory administrator.	Ядро	GA
az mysql flexible-server ad-admin create	Create an Active Directory administrator.	Ядро	GA
az mysql flexible-server ad-admin delete	Delete an Active Directory administrator.	Ядро	GA
az mysql flexible-server ad-admin list	List all Active Directory administrators.	Ядро	GA
az mysql flexible-server ad-admin show	Get an Active Directory administrator.	Ядро	GA
az mysql flexible-server ad-admin wait	Wait for the Active Directory administrator to satisfy certain conditions.	Ядро	GA
az mysql flexible-server advanced-threat-protection-setting	Manage the server's advanced threat protection setting.	Ядро	GA
az mysql flexible-server advanced-threat-protection-setting show	Get the server's advanced threat protection setting.	Ядро	GA
az mysql flexible-server advanced-threat-protection-setting update	Update the server's advanced threat protection setting.	Ядро	GA
az mysql flexible-server backup	Manage flexible server backups.	Ядро	GA
az mysql flexible-server backup create	Create a backup for a given server with specified backup name.	Ядро	GA
az mysql flexible-server backup list	List all the backups for a given server.	Ядро	GA
az mysql flexible-server backup show	Show the details of a specific backup for a given server.	Ядро	GA
az mysql flexible-server connect	Connect to a flexible server.	Расширение	GA
az mysql flexible-server create	Create a MySQL flexible server.	Ядро	GA
az mysql flexible-server db	Manage MySQL databases on a flexible server.	Ядро	GA
az mysql flexible-server db create	Create a MySQL database on a flexible server.	Ядро	GA
az mysql flexible-server db delete	Delete a database on a flexible server.	Ядро	GA
az mysql flexible-server db list	List the databases for a flexible server.	Ядро	GA
az mysql flexible-server db show	Show the details of a database.	Ядро	GA
az mysql flexible-server delete	Delete a flexible server.	Ядро	GA
az mysql flexible-server deploy	Enable and run GitHub Actions workflow for MySQL server.	Ядро	GA
az mysql flexible-server deploy run	Run an existing workflow in your github repository.	Ядро	GA
az mysql flexible-server deploy setup	Create GitHub Actions workflow file for MySQL server.	Ядро	GA
az mysql flexible-server detach-vnet	Detach vnet for a flexible server.	Ядро	GA
az mysql flexible-server execute	Connect to a flexible server.	Расширение	GA
az mysql flexible-server export	Manage export backup on a server.	Ядро	Предварительный просмотр
az mysql flexible-server export create	Create an export backup for a given server with specified backup name.	Ядро	Предварительный просмотр
az mysql flexible-server firewall-rule	Manage firewall rules for a server.	Ядро	GA
az mysql flexible-server firewall-rule create	Create a new firewall rule for a flexible server.	Ядро	GA
az mysql flexible-server firewall-rule delete	Delete a firewall rule.	Ядро	GA
az mysql flexible-server firewall-rule list	List all firewall rules for a flexible server.	Ядро	GA
az mysql flexible-server firewall-rule show	Get the details of a firewall rule.	Ядро	GA
az mysql flexible-server firewall-rule update	Update a firewall rule.	Ядро	GA
az mysql flexible-server geo-restore	Geo-restore a flexible server from backup.	Ядро	GA
az mysql flexible-server gtid	Manage GTID on a server.	Ядро	GA
az mysql flexible-server gtid reset	Resets GTID on a server.	Ядро	GA
az mysql flexible-server identity	Manage server user assigned identities.	Ядро	GA
az mysql flexible-server identity assign	Add user asigned managed identities to the server.	Ядро	GA
az mysql flexible-server identity list	List all user assigned managed identities from the server.	Ядро	GA
az mysql flexible-server identity remove	Remove user asigned managed identites from the server.	Ядро	GA
az mysql flexible-server identity show	Get an user assigned managed identity from the server.	Ядро	GA
az mysql flexible-server import	Manage import workflows for MySQL Flexible Servers.	Ядро	GA
az mysql flexible-server import create	Create a new import workflow for flexible server.	Ядро	GA
az mysql flexible-server import stop-replication	To stop replication between the source single server and target flexible server.	Ядро	GA
az mysql flexible-server list	List available flexible servers.	Ядро	GA
az mysql flexible-server list-skus	Lists available sku's in the given region.	Ядро	GA
az mysql flexible-server maintenance	Manage maintenance on a flexible server.	Ядро	GA
az mysql flexible-server maintenance list	List all of the maintenances of a flexible server.	Ядро	GA
az mysql flexible-server maintenance reschedule	Reschedule the ongoing planned maintenance of a flexible server.	Ядро	GA
az mysql flexible-server maintenance show	Get the specific maintenance of a flexible server by maintenance name.	Ядро	GA
az mysql flexible-server parameter	Commands for managing server parameter values for flexible server.	Ядро	GA
az mysql flexible-server parameter list	List the parameter values for a flexible server.	Ядро	GA
az mysql flexible-server parameter set	Update the parameter of a flexible server.	Ядро	GA
az mysql flexible-server parameter set-batch	Batch update parameters of a flexible server.	Ядро	GA
az mysql flexible-server parameter show	Get the parameter for a flexible server.".	Ядро	GA
az mysql flexible-server replica	Manage read replicas.	Ядро	GA
az mysql flexible-server replica create	Create a read replica for a server.	Ядро	GA
az mysql flexible-server replica list	List all read replicas for a given server.	Ядро	GA
az mysql flexible-server replica stop-replication	Stop replication to a read replica and make it a read/write server.	Ядро	GA
az mysql flexible-server restart	Restart a flexible server.	Ядро	GA
az mysql flexible-server restore	Restore a flexible server from backup.	Ядро	GA
az mysql flexible-server server-logs	Manage server logs.	Ядро	GA
az mysql flexible-server server-logs download	Download log files.	Ядро	GA
az mysql flexible-server server-logs list	List log files for a server.	Ядро	GA
az mysql flexible-server show	Get the details of a flexible server.	Ядро	GA
az mysql flexible-server show-connection-string	Show the connection strings for a MySQL flexible-server database.	Ядро	GA
az mysql flexible-server start	Start a flexible server.	Ядро	GA
az mysql flexible-server stop	Stop a flexible server.	Ядро	GA
az mysql flexible-server update	Update a flexible server.	Ядро	GA
az mysql flexible-server upgrade	Upgrade the major version of a flexible server.	Ядро	GA
az mysql flexible-server wait	Wait for the flexible server to satisfy certain conditions.	Ядро	GA

az mysql flexible-server connect --admin-user
                                 --name
                                 [--admin-password]
                                 [--database-name]
                                 [--interactive]
                                 [--querytext]

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server create [--accelerated-logs {Disabled, Enabled}]
                                [--address-prefixes]
                                [--admin-password]
                                [--admin-user]
                                [--auto-scale-iops {Disabled, Enabled}]
                                [--backup-identity]
                                [--backup-key]
                                [--backup-retention]
                                [--database-name]
                                [--database-port]
                                [--geo-redundant-backup {Disabled, Enabled}]
                                [--high-availability {Disabled, SameZone, ZoneRedundant}]
                                [--identity]
                                [--iops]
                                [--key]
                                [--location]
                                [--maintenance-policy-patch-strategy {Regular, VirtualCanary}]
                                [--name]
                                [--private-dns-zone]
                                [--public-access]
                                [--resource-group]
                                [--sku-name]
                                [--standby-zone]
                                [--storage-auto-grow {Disabled, Enabled}]
                                [--storage-redundancy {LocalRedundancy, ZoneRedundancy}]
                                [--storage-size]
                                [--subnet]
                                [--subnet-prefixes]
                                [--tags]
                                [--tier]
                                [--version]
                                [--vnet]
                                [--yes]
                                [--zone]

Примеры

Create a MySQL flexible server with custom parameters

az mysql flexible-server create --location northeurope --resource-group testGroup \
  --name testserver --admin-user username --admin-password password \
  --sku-name Standard_B1ms --tier Burstable --public-access 0.0.0.0 --storage-size 32 \
  --tags "key=value" --version 5.7 --high-availability ZoneRedundant --zone 1 \
  --standby-zone 3 --storage-auto-grow Enabled --iops 500

Create a MySQL flexible server with default parameters and public access enabled by default. Resource group, server name, username, password, and default database will be created by CLI

az mysql flexible-server create

Create a MySQL flexible server with public access and add the range of IP address to have access to this server. The --public-access parameter can be 'All', 'None', <startIpAddress>, or <startIpAddress>-<endIpAddress>

az mysql flexible-server create --resource-group testGroup --name testserver --public-access 125.23.54.31-125.23.54.35

Create a MySQL flexible server with private access. If provided virtual network and subnet do not exists, virtual network and subnet with the specified address prefixes will be created.

az mysql flexible-server create --resource-group testGroup --name testserver --vnet myVnet --subnet mySubnet --address-prefixes 10.0.0.0/16 --subnet-prefixes 10.0.0.0/24

Create a MySQL flexible server using a new subnet resource ID and new private DNS zone resource ID. The subnet and DNS zone can be created in different subscription or resource group.

az mysql flexible-server create \
  --resource-group testGroup --name testserver \
  --subnet /subscriptions/{SubID}/resourceGroups/{ResourceGroup}/providers/Microsoft.Network/virtualNetworks/{VNetName}/subnets/{SubnetName} \
  --private-dns-zone /subscriptions/{SubID}/resourceGroups/{resourceGroup}/providers/Microsoft.Network/privateDnsZones/testMySQLFlexibleDnsZone.private.mysql.database.azure.com \
  --address-prefixes 172.0.0.0/16 --subnet-prefixes 172.0.0.0/24

Create a MySQL flexible server using existing network resources in the same resource group. The provided subnet should not have any other resource deployed in it and this subnet will be delegated to Microsoft.DBforMySQL/flexibleServers, if not already delegated. The private DNS zone will be linked to the virtual network if not already linked.

# create vnet
az network vnet create --resource-group testGroup --name testVnet --location testLocation --address-prefixes 172.0.0.0/16

# create subnet
az network vnet subnet create --resource-group testGroup --vnet-name testVnet --address-prefixes 172.0.0.0/24 --name testSubnet

# create private dns zone
az network private-dns zone create -g testGroup -n testDNS.private.mysql.database.azure.com

az mysql flexible-server create --resource-group testGroup \
  --name testserver --location testLocation \
  --subnet /subscriptions/{SubId}/resourceGroups/{testGroup}/providers/Microsoft.Network/virtualNetworks/tesetVnet/subnets/testSubnet \
  --private-dns-zone /subscriptions/{SubId}/resourceGroups/{testGroup}/providers/Microsoft.Network/privateDnsZones/testDNS.mysql.database.azure.com\


az mysql flexible-server create --resource-group testGroup --name testserver \
  --vnet testVnet --subnet testSubnet --location testLocation \
  --private-dns-zone /subscriptions/{SubId}/resourceGroups/{testGroup}/providers/Microsoft.Network/privateDnsZones/testDNS.mysql.database.azure.com

Create a MySQL flexible server using existing network resources in the different resource group / subscription.

az mysql flexible-server create --resource-group testGroup \
   --name testserver --location testLocation \
  --subnet /subscriptions/{SubId2}/resourceGroups/{testGroup2}/providers/Microsoft.Network/virtualNetworks/tesetVnet/subnets/testSubnet \
  --private-dns-zone /subscriptions/{SubId2}/resourceGroups/{testGroup2}/providers/Microsoft.Network/privateDnsZones/testDNS.mysql.database.azure.com

Create a MySQL flexible server with data encryption.

# create keyvault
az keyvault create -g testGroup -n testVault --location testLocation \
  --enable-purge-protection true


# create key in keyvault and save its key identifier
keyIdentifier=$(az keyvault key create --name testKey -p software \
  --vault-name testVault --query key.kid -o tsv)


# create identity and save its principalId
identityPrincipalId=$(az identity create -g testGroup --name testIdentity \
  --location testLocation --query principalId -o tsv)


# add testIdentity as an access policy with key permissions 'Wrap Key', 'Unwrap Key', 'Get' and 'List' inside testVault
az keyvault set-policy -g testGroup -n testVault --object-id $identityPrincipalId \
  --key-permissions wrapKey unwrapKey get list


# create flexible server with data encryption enabled
az mysql flexible-server create -g testGroup -n testServer --location testLocation \
  --key $keyIdentifier --identity testIdentity

Create a MySQL flexible server with geo redundant backup and data encryption.

# create keyvault
az keyvault create -g testGroup -n testVault --location testLocation \
  --enable-purge-protection true


# create key in keyvault and save its key identifier
keyIdentifier=$(az keyvault key create --name testKey -p software \
  --vault-name testVault --query key.kid -o tsv)


# create identity and save its principalId
identityPrincipalId=$(az identity create -g testGroup --name testIdentity \
  --location testLocation --query principalId -o tsv)


# add testIdentity as an access policy with key permissions 'Wrap Key', 'Unwrap Key', 'Get' and 'List' inside testVault
az keyvault set-policy -g testGroup -n testVault --object-id $identityPrincipalId \
  --key-permissions wrapKey unwrapKey get list


# create backup keyvault
az keyvault create -g testGroup -n testBackupVault --location testBackupLocation \
  --enable-purge-protection true


# create backup key in backup keyvault and save its key identifier
backupKeyIdentifier=$(az keyvault key create --name testBackupKey -p software \
  --vault-name testBackupVault --query key.kid -o tsv)


# create backup identity and save its principalId
backupIdentityPrincipalId=$(az identity create -g testGroup --name testBackupIdentity \
  --location testBackupLocation --query principalId -o tsv)


# add testBackupIdentity as an access policy with key permissions 'Wrap Key', 'Unwrap Key', 'Get' and 'List' inside testBackupVault
az keyvault set-policy -g testGroup -n testBackupVault \
  --object-id $backupIdentityPrincipalId --key-permissions wrapKey unwrapKey get list


# create flexible server with geo redundant backup and data encryption enabled
az mysql flexible-server create -g testGroup -n testServer --location testLocation \
  --geo-redundant-backup Enabled \
  --key $keyIdentifier --identity testIdentity \
  --backup-key $backupKeyIdentifier --backup-identity testBackupIdentity

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server delete [--ids]
                                [--name]
                                [--resource-group]
                                [--subscription]
                                [--yes]

Примеры

Delete a flexible server.

az mysql flexible-server delete --resource-group testGroup --name testserver

Delete a flexible server without confirmation prompt.

az mysql flexible-server delete --resource-group testGroup --name testserver --yes

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server detach-vnet --public-network-access {Disabled, Enabled}
                                     [--ids]
                                     [--name]
                                     [--resource-group]
                                     [--subscription]
                                     [--yes]

Примеры

Detach vnet for a flexible server with public access disabled.

az mysql flexible-server detach-vnet --resource-group testGroup --name testserver --public-network-access Disabled

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server execute --admin-password
                                 --admin-user
                                 --name
                                 [--database-name]
                                 [--file-path]
                                 [--querytext]

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server geo-restore --location
                                     --source-server
                                     [--accelerated-logs {Disabled, Enabled}]
                                     [--address-prefixes]
                                     [--backup-retention]
                                     [--geo-redundant-backup {Disabled, Enabled}]
                                     [--ids]
                                     [--name]
                                     [--no-wait]
                                     [--private-dns-zone]
                                     [--public-access {Disabled, Enabled}]
                                     [--resource-group]
                                     [--sku-name]
                                     [--storage-auto-grow {Disabled, Enabled}]
                                     [--storage-redundancy {LocalRedundancy, ZoneRedundancy}]
                                     [--storage-size]
                                     [--subnet]
                                     [--subnet-prefixes]
                                     [--subscription]
                                     [--tags]
                                     [--tier]
                                     [--vnet]
                                     [--yes]
                                     [--zone]

Примеры

Geo-restore 'testserver' to a new server 'testserverNew' in location 'newLocation' with the same network configuration. Private access server will use different private dns zone.

az mysql flexible-server geo-restore --resource-group testGroup --name testserverNew --source-server testserver --location newLocation

Geo-restore public access or private access server 'testserver' as a new server 'testserverNew' with new subnet. New vnet, subnet, and private dns zone for the restored server will be provisioned. Please refer to 'flexible-server create' command for more private access scenarios.

az mysql flexible-server geo-restore --resource-group testGroup --name testserverNew \
  --source-server testserver --vnet newVnet --subnet newSubnet \
  --address-prefixes 172.0.0.0/16 --subnet-prefixes 172.0.0.0/24 \
  --private-dns-zone testDNS.mysql.database.azure.com --location newLocation

Geo-restore private access server 'testserver' as a new server 'testserverNew' with public access.

az mysql flexible-server geo-restore --resource-group testGroup --name testserverNew  --source-server testserver --public-access Enabled --location newLocation

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server list [--resource-group]

Примеры

List all MySQL flexible servers in a subscription.

az mysql flexible-server list

List all MySQL flexible servers in a resource group.

az mysql flexible-server list --resource-group testGroup

List all MySQL flexible servers in a resource group in table format.

az mysql flexible-server list --resource-group testGroup --output table

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server list-skus --location

Примеры

Lists available sku's in the given region.

az mysql flexible-server list-skus -l eastus

Lists available sku's in the given region in table output

az mysql flexible-server list-skus -l eastus -o table

Обязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server restart [--failover]
                                 [--ids]
                                 [--name]
                                 [--resource-group]
                                 [--subscription]

Примеры

Restart a flexible server.

az mysql flexible-server restart --resource-group testGroup --name testserver

Restart a flexible server with failover

az mysql flexible-server restart --resource-group testGroup --name testserver --failover Forced

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server restore --source-server
                                 [--accelerated-logs {Disabled, Enabled}]
                                 [--address-prefixes]
                                 [--backup-retention]
                                 [--database-port]
                                 [--geo-redundant-backup {Disabled, Enabled}]
                                 [--ids]
                                 [--name]
                                 [--no-wait]
                                 [--private-dns-zone]
                                 [--public-access {Disabled, Enabled}]
                                 [--resource-group]
                                 [--restore-time]
                                 [--sku-name]
                                 [--storage-auto-grow {Disabled, Enabled}]
                                 [--storage-redundancy {LocalRedundancy, ZoneRedundancy}]
                                 [--storage-size]
                                 [--subnet]
                                 [--subnet-prefixes]
                                 [--subscription]
                                 [--tags]
                                 [--tier]
                                 [--vnet]
                                 [--yes]
                                 [--zone]

Примеры

Restore 'testserver' to a specific point-in-time as a new server 'testserverNew' with the same network configuration.

az mysql flexible-server restore --resource-group testGroup --name testserverNew --source-server testserver --restore-time "2017-06-15T13:10:00Z"

Restore public access or private access server 'testserver' as a new server 'testserverNew' with new subnet to current point-in-time. New vnet, subnet, and private dns zone for the restored server will be provisioned. Please refer to 'flexible-server create' command for more private access scenarios.

az mysql flexible-server restore --resource-group testGroup --name testserverNew \
  --source-server testserver --vnet newVnet --subnet newSubnet \
  --address-prefixes 172.0.0.0/16 --subnet-prefixes 172.0.0.0/24 \
  --private-dns-zone testDNS.mysql.database.azure.com

Restore private access server 'testserver' to current point-in-time as a new server 'testserverNew' with public access.

az mysql flexible-server restore --resource-group testGroup --name testserverNew \
  --source-server testserver --public-access Enabled

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server show [--ids]
                              [--name]
                              [--resource-group]
                              [--subscription]

Примеры

Get the details of a flexible server

az mysql flexible-server show --resource-group testGroup --name testserver

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server show-connection-string [--admin-password]
                                                [--admin-user]
                                                [--database-name]
                                                [--ids]
                                                [--server-name]
                                                [--subscription]

Примеры

Show connection strings for cmd and programming languages.

az mysql flexible-server show-connection-string -s testserver -u username -p password -d databasename

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server start [--ids]
                               [--name]
                               [--no-wait]
                               [--resource-group]
                               [--subscription]

Примеры

Start a flexible server.

az mysql flexible-server start --resource-group testGroup --name testserver

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server stop [--ids]
                              [--name]
                              [--no-wait]
                              [--resource-group]
                              [--subscription]

Примеры

Stop a flexible server.

az mysql flexible-server stop --resource-group testGroup --name testserver

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server update [--accelerated-logs {Disabled, Enabled}]
                                [--add]
                                [--admin-password]
                                [--auto-scale-iops {Disabled, Enabled}]
                                [--backup-identity]
                                [--backup-key]
                                [--backup-retention]
                                [--disable-data-encryption {false, true}]
                                [--force-string]
                                [--geo-redundant-backup {Disabled, Enabled}]
                                [--high-availability {Disabled, SameZone, ZoneRedundant}]
                                [--identity]
                                [--ids]
                                [--iops]
                                [--key]
                                [--maintenance-policy-patch-strategy {Regular, VirtualCanary}]
                                [--maintenance-window]
                                [--name]
                                [--public-access {Disabled, Enabled}]
                                [--remove]
                                [--replication-role]
                                [--resource-group]
                                [--set]
                                [--sku-name]
                                [--standby-zone]
                                [--storage-auto-grow {Disabled, Enabled}]
                                [--storage-size]
                                [--subscription]
                                [--tags]
                                [--tier]

Примеры

Update a flexible server's sku, using local context for server and resource group.

az mysql flexible-server update --sku-name Standard_D4ds_v4 --tier GeneralPurpose

Update a flexible server's tags.

az mysql flexible-server update --resource-group testGroup --name testserver --tags "k1=v1" "k2=v2"

Set or change key and identity for data encryption.

# get key identifier of the existing key
newKeyIdentifier=$(az keyvault key show --vault-name testVault --name testKey \
  --query key.kid -o tsv)


# update server with new key/identity
az mysql flexible-server update --resource-group testGroup --name testserver \
  --key $newKeyIdentifier --identity newIdentity

Set or change key, identity, backup key and backup identity for data encryption with geo redundant backup.

# get key identifier of the existing key and backup key
newKeyIdentifier=$(az keyvault key show --vault-name testVault --name testKey \
  --query key.kid -o tsv)

newBackupKeyIdentifier=$(az keyvault key show --vault-name testBackupVault \
  --name testBackupKey --query key.kid -o tsv)


# update server with new key/identity and backup key/identity
az mysql flexible-server update --resource-group testGroup --name testserver \
  --key $newKeyIdentifier --identity newIdentity \
  --backup-key $newBackupKeyIdentifier --backup-identity newBackupIdentity

Disable data encryption for flexible server.

az mysql flexible-server update --resource-group testGroup --name testserver \
  --disable-data-encryption

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server upgrade --version {8}
                                 [--ids]
                                 [--name]
                                 [--resource-group]
                                 [--subscription]
                                 [--yes]

Примеры

Upgrade server 'testsvr' to MySQL major version 8.

# make sure that sql_mode only contains values allowed in new version, for example:
az mysql flexible-server parameter set -g testgroup -s testsvr -n sql_mode \
  -v "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"

# upgrade server to MySQL major version 8.
az mysql flexible-server upgrade -g testgroup -n testsvr -v 8

Обязательные параметры

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az mysql flexible-server wait [--created]
                              [--custom]
                              [--deleted]
                              [--exists]
                              [--ids]
                              [--interval]
                              [--name]
                              [--resource-group]
                              [--subscription]
                              [--timeout]
                              [--updated]

Примеры

Wait for the flexible server to satisfy certain conditions.

az mysql flexible-server wait --exists --resource-group testGroup --name testserver

Необязательные параметры

Глобальные параметры

--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Отображать только ошибки, не показывая предупреждения.

--output -o

Output format.

Допустимые значения: json, jsonc, none, table, tsv, yaml, yamlc

Default value: json

--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Имя или идентификатор подписки. Подписку по умолчанию можно настроить с помощью az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.