This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge

Examples

List the parameter values for a flexible server.

az mysql flexible-server parameter list --resource-group testGroup --server-name testserver

List the parameter values for a flexible server in table format.

az mysql flexible-server parameter list --resource-group testGroup --server-name testserver --output table

Required Parameters

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name> .

--server-name -s

Name of the server. The name can contain only lowercase letters, numbers, and the hyphen (-) character. Minimum 3 characters and maximum 63 characters.

Optional Parameters

--keyword

The keyword of the server configuration. Default value is None.

--page

The page of the server configuration. Default value is None.

--page-size

The pageSize of the server configuration. Default value is None.

--tags

The tags of the server configuration. Default value is None.

--query

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

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID .

--verbose

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

Examples

Set a new parameter value.

az mysql flexible-server parameter set --resource-group testGroup --server-name testserver --name parameterName --value parameterValue

Set a parameter value to its default.

az mysql flexible-server parameter set --resource-group testGroup --server-name testserver --name parameterName

Optional Parameters

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--name -n

The name of the server configuration.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name> .

--server-name -s

Name of the server. The name can contain only lowercase letters, numbers, and the hyphen (-) character. Minimum 3 characters and maximum 63 characters.

--source

Source of the configuration.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID .

--value -v

Value of the configuration.

--query

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

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID .

--verbose

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

Examples

Get the parameter for a server.

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

Optional Parameters

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--name -n

The name of the server configuration.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name> .

--server-name -s

Name of the server. The name can contain only lowercase letters, numbers, and the hyphen (-) character. Minimum 3 characters and maximum 63 characters.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID .

--query

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

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID .

--verbose

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