https://docs.microsoft.com/ja-jp/azure/mysql/tutorial-design-database-using-cli
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
# リソースグループ作成 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" } # |
