az mysql db
Manage MySQL databases on a server.
Commands
Name | Description | Type | Status |
---|---|---|---|
az mysql db create |
Create a MySQL database. |
Core | GA |
az mysql db delete |
Delete a database. |
Core | GA |
az mysql db list |
List the databases for a server. |
Core | GA |
az mysql db show |
Show the details of a database. |
Core | GA |
az mysql db create
Create a MySQL database.
az mysql db create --name
--resource-group
--server-name
[--charset]
[--collation]
Examples
Create database 'testdb' in the server 'testsvr' with the default parameters.
az mysql db create -g testgroup -s testsvr -n testdb
Create database 'testdb' in server 'testsvr' with a given character set and collation rules.
az mysql db create -g testgroup -s testsvr -n testdb --charset {valid_charset} --collation {valid_collation}
Required Parameters
The name of the database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
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
The charset of the database.
The collation of the database.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az mysql db delete
Delete a database.
az mysql db delete --name
[--ids]
[--resource-group]
[--server-name]
[--subscription]
[--yes]
Examples
Delete database 'testdb' in the server 'testsvr'.
az mysql db delete -g testgroup -s testsvr -n testdb
Required Parameters
The name of the database.
Optional Parameters
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 of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the server. The name can contain only lowercase letters, numbers, and the hyphen (-) character. Minimum 3 characters and maximum 63 characters.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Do not prompt for confirmation.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az mysql db list
List the databases for a server.
az mysql db list --resource-group
--server-name
Examples
List databases in the server 'testsvr'.
az mysql db list -g testgroup -s testsvr
Required Parameters
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the Server.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az mysql db show
Show the details of a database.
az mysql db show --name
[--ids]
[--resource-group]
[--server-name]
[--subscription]
Examples
Show database 'testdb' in the server 'testsvr'.
az mysql db show -g testgroup -s testsvr -n testdb
Required Parameters
The name of the database.
Optional Parameters
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 of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the server. The name can contain only lowercase letters, numbers, and the hyphen (-) character. Minimum 3 characters and maximum 63 characters.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.