参考:https://docs.microsoft.com/en-us/python/api/overview/azure/postgresql-mysql?view=azure-python
首先:
pip install azure-mgmt-rdbms
demo文件
from azure.mgmt.rdbms.mysql import MySQLManagementClient
from azure.mgmt.rdbms.mysql.models import *
SUBSCRIPTION_ID = "YOUR_AZURE_SUBSCRIPTION_ID"
RESOURCE_GROUP = "YOUR_AZURE_RESOURCE_GROUP"
SERVER = "YOUR_SERVER_NAME"
ADMIN_USER = "YOUR_ADMIN_USERNAME"
ADMIN_PASSWORD = "YOUR_ADMIN_PASSWORD"
LOCATION = "westus"
client = MySQLManagementClient(credentials=creds,
subscription_id=SUBSCRIPTION_ID)
server_creation_poller = client.servers.create(
RESOURCE_GROUP,
SERVER,
ServerForCreate(
properties=ServerPropertiesForDefaultCreate(
administrator_login=ADMIN_USER,
administrator_login_password=ADMIN_PASSWORD,
version=ServerVersion.one_one,
storage_profile=StorageProfile(
storage_mb=51200
)
),
location=LOCATION,
sku=Sku(
name="GP_Gen5_2"
)
)
)
server = server_creation_poller.result()
# Open access to this server for IPs
rule_creation_poller = client.firewall_rules.create_or_update(
RESOURCE_GROUP,
SERVER,
"example_firewall_rule", # Custom firewall rule name
"123.123.123.123", # Start ip range
"123.123.123.124" # End ip range
)
firewall_rule = rule_creation_poller.result()