【Azure】Azure Database for MySQLをazcliでつくる

https://docs.microsoft.com/ja-jp/azure/mysql/tutorial-design-database-using-cli

# リソースグループ作成
az group create --name myresourcegroup --location westus

# MySQL作成
az mysql server create --resource-group myresourcegroup --name mydemoserver0910  --location westus --admin-user myadmin --admin-password P@ssw0rd --sku-name GP_Gen5_2 --version 5.7

# ファイアウォール規則
az mysql server firewall-rule create --resource-group myresourcegroup --server mydemoserver0910 --name AllowMyIP --start-ip-address 192.168.0.1 --end-ip-address 192.168.0.1

# SSL接続解除（一時的にっぽい）
az mysql server update --resource-group myresourcegroup --name mydemoserver0910 --ssl-enforcement Disabled

# 接続情報
az mysql server show --resource-group myresourcegroup --name mydemoserver

{
  "administratorLogin": "myadmin",
  "earliestRestoreDate": "2020-04-26T00:35:21.897000+00:00",
  "fullyQualifiedDomainName": "mydemoserver0910.mysql.database.azure.com",
  "id": "/subscriptions/8778db7d-b7a6-4d4c-8806-489df6a596c5/resourceGroups/myresourcegroup/providers/Microsoft.DBforMySQL/servers/mydemoserver0910",
  "location": "westus",
  "masterServerId": "",
  "name": "mydemoserver0910",
  "replicaCapacity": 5,
  "replicationRole": "None",
  "resourceGroup": "myresourcegroup",
  "sku": {
    "capacity": 2,
    "family": "Gen5",
    "name": "GP_Gen5_2",
    "size": null,
    "tier": "GeneralPurpose"
  },
  "sslEnforcement": "Disabled",
  "storageProfile": {
    "backupRetentionDays": 7,
    "geoRedundantBackup": "Disabled",
    "storageAutogrow": "Enabled",
    "storageMb": 5120
  },
  "tags": null,
  "type": "Microsoft.DBforMySQL/servers",
  "userVisibleState": "Ready",
  "version": "5.7"
}

#