Azure Database for MySQL: Openapi
The Microsoft Azure management API provides create, read, update, and delete functionality for Azure MySQL resources including servers, databases, firewall…
Fork copies the collection into your workspace, without the publisher's secrets, so you can add your own key and send requests. Star saves it to your starred APIs (Account › Marketplace) and helps others find it.
Overview
The Microsoft Azure management API provides create, read, update, and delete functionality for Azure MySQL resources including servers, databases, firewall rules, VNET rules, log files and configurations with new business model.
Endpoints 64
Operations
- GETOperations_List
/providers/Microsoft.DBforMySQL/operationsList the operations for the provider
AzureADAdministrators
- GETAzureADAdministrators_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/administratorsList all the AAD administrators in a given server. - GETAzureADAdministrators_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/administrators/:administratorNameGets information about an azure ad administrator. - PUTAzureADAdministrators_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/administrators/:administratorNameCreates or updates an existing Azure Active Directory administrator. - DELETEAzureADAdministrators_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/administrators/:administratorNameDeletes an Azure AD Administrator.
Servers
- GETServers_List
/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/flexibleServersList all the servers in a given subscription. - GETServers_ListByResourceGroup
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServersList all the servers in a given resource group. - GETServers_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverNameGets information about a server. - PUTServers_Create
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverNameCreates a new server or updates an existing server. The update action will overwrite the existing server. - DELETEServers_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverNameDeletes a server. - PATCHServers_Update
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverNameUpdates an existing server. The request body can contain one to many of the properties present in the normal server definition. - POSTServers_DetachVNet
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/detachVNetDetach VNet on a server. - POSTServers_Failover
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/failoverManual failover a server. - POSTServers_ResetGtid
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/resetGtidResets GTID on a server. - POSTServers_Restart
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/restartRestarts a server. - POSTServers_Start
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/startStarts a server. - POSTServers_Stop
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/stopStops a server. - POSTServers_ValidateEstimateHighAvailability
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/validateEstimateHighAvailabilityValidate a deployment of high availability.
BackupAndExport
- POSTBackupAndExport_Create
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/backupAndExportExports the backup of the given server by creating a backup if not existing. - POSTBackupAndExport_ValidateBackup
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/validateBackupValidates if backup can be performed for given server.
LogFiles
- GETLogFiles_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/logFilesList all the server log files in a given server.
ServersMigration
- POSTServersMigration_CutoverMigration
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/cutoverMigrationCutover migration for MySQL import, it will switch source elastic server DNS to flexible server.
Backups
- GETBackups_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/backupsList all the backups for a given server. - GETBackups_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/backups/:backupNameList all the backups for a given server. - PUTBackups_Put
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/backups/:backupNameCreate backup for a given server with specified backup name.
LongRunningBackups
- GETLongRunningBackups_List
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/backupsV2List all the backups for a given server. - GETLongRunningBackups_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/backupsV2/:backupNameGet backup for a given server.
LongRunningBackup
- PUTLongRunningBackup_Create
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/backupsV2/:backupNameCreate backup for a given server with specified backup name.
Configurations
- GETConfigurations_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/configurations?tags=string&keyword=string&page=0&pageSize=0List all the configurations in a given server. - GETConfigurations_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/configurations/:configurationNameGets information about a configuration of server. - PUTConfigurations_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/configurations/:configurationNameUpdates a configuration of a server. - PATCHConfigurations_Update
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/configurations/:configurationNameUpdates a configuration of a server. - POSTConfigurations_BatchUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/updateConfigurationsUpdate a list of configurations in a given server.
Databases
- GETDatabases_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/databasesList all the databases in a given server. - GETDatabases_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/databases/:databaseNameGets information about a database. - PUTDatabases_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/databases/:databaseNameCreates a new database or updates an existing database. - DELETEDatabases_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/databases/:databaseNameDeletes a database.
FirewallRules
- GETFirewallRules_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/firewallRulesList all the firewall rules in a given server. - GETFirewallRules_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/firewallRules/:firewallRuleNameGets information about a server firewall rule. - PUTFirewallRules_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/firewallRules/:firewallRuleNameCreates a new firewall rule or updates an existing firewall rule. - DELETEFirewallRules_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/firewallRules/:firewallRuleNameDeletes a firewall rule.
AdvancedThreatProtectionSettings
- GETAdvancedThreatProtectionSettings_List
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/advancedThreatProtectionSettingsGets a list of server's Advanced Threat Protection states. - GETAdvancedThreatProtectionSettings_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/advancedThreatProtectionSettings/:advancedThreatProtectionNameGet a server's Advanced Threat Protection state - PUTAdvancedThreatProtectionSettings_UpdatePut
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/advancedThreatProtectionSettings/:advancedThreatProtectionNameUpdates a server's Advanced Threat Protection state. - PATCHAdvancedThreatProtectionSettings_Update
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/advancedThreatProtectionSettings/:advancedThreatProtectionNameUpdates a server's Advanced Threat Protection state.
LocationBasedCapabilitySet
- GETLocationBasedCapabilitySet_List
/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/locations/:locationName/capabilitySetsGet capabilities at specified location in a given subscription. - GETLocationBasedCapabilitySet_Get
/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/locations/:locationName/capabilitySets/:capabilitySetNameGet capabilities at specified location in a given subscription.
Maintenances
- GETMaintenances_List
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/maintenancesList maintenances. - GETMaintenances_Read
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/maintenances/:maintenanceNameRead maintenance. - PATCHMaintenances_Update
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/maintenances/:maintenanceNameUpdate maintenances.
PrivateEndpointConnections
- GETPrivateEndpointConnections_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/privateEndpointConnectionsGets all private endpoint connections on a server. - GETPrivateEndpointConnections_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/privateEndpointConnections/:privateEndpointConnectionNameGets a private endpoint connection. - PUTPrivateEndpointConnections_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/privateEndpointConnections/:privateEndpointConnectionNameApprove or reject a private endpoint connection with a given name. - DELETEPrivateEndpointConnections_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/privateEndpointConnections/:privateEndpointConnectionNameDeletes a private endpoint connection with a given name.
PrivateLinkResources
- GETPrivateLinkResources_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/privateLinkResourcesLists the private link resources for MySQL server. - GETPrivateLinkResources_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/privateLinkResources/:groupNameGets a private link resource for MySQL server.
Replicas
- GETReplicas_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/flexibleServers/:serverName/replicasList all the replicas for a given server.
- POSTGetPrivateDnsZoneSuffix_Execute
/providers/Microsoft.DBforMySQL/getPrivateDnsZoneSuffixGet private DNS zone suffix in the cloud. - POSTCheckNameAvailabilityWithoutLocation_Execute
/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/checkNameAvailabilityCheck the availability of name for server - GETLocationBasedCapabilities_List
/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/locations/:locationName/capabilitiesGet capabilities at specified location in a given subscription. - POSTCheckNameAvailability_Execute
/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/locations/:locationName/checkNameAvailabilityCheck the availability of name for server - POSTCheckVirtualNetworkSubnetUsage_Execute
/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/locations/:locationName/checkVirtualNetworkSubnetUsageGet virtual network subnet usage for a given vNet resource id. - GETGet the operation result for a long running operation.
/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/locations/:locationName/operationProgress/:operationIdGet the operation result for a long running operation. - GETGet the operation result for a long running operation.
/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/locations/:locationName/operationResults/:operationIdGet the operation result for a long running operation.
API details
- Base URL
https://management.azure.com- Authentication
- OAuth 2.0 (implicit flow) with 1 scope
- Operations
- 64 operations on 46 pathsGET 31POST 15PUT 9DELETE 5PATCH 4
- Main resources
- Servers 13Configurations 5AdvancedThreatProtectionSettings 4AzureADAdministrators 4Databases 4FirewallRules 4PrivateEndpointConnections 4Backups 3Maintenances 3BackupAndExport 2
- Response formats
application/json- Description format
- Swagger 2.0, API version
2024-12-30 - Links
- OpenAPI document
How to test the Azure Database for MySQL: Openapi in Swastik Codes
- Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
- Fork it into your workspaceChoose a workspace. You get your own copy of the Azure Database for MySQL: Openapi collection, without the publisher's secrets.
- Add your credentialsThis API uses OAuth 2.0 (implicit flow) with 1 scope. Add yours in the collection's variables or an environment; the requests already reference it.
- Send a requestPick an endpoint, for example “Operations_List” (GET /providers/Microsoft.DBforMySQL/operations), and press Send. Check the response, add tests and run the whole collection with the runner.
Frequently asked questions
What is the Azure Database for MySQL: Openapi?
The Microsoft Azure management API provides create, read, update, and delete functionality for Azure MySQL resources including servers, databases, firewall… It is listed under Data & analytics and has 64 endpoints.
Who publishes the Azure Database for MySQL: Openapi?
It is listed from Microsoft Azure's public API description (an OpenAPI document), not published by Microsoft Azure on Swastik Codes. Anyone who controls azure.com can claim the profile by adding a DNS TXT record.
What is the base URL of the Azure Database for MySQL: Openapi?
Requests go to https://management.azure.com. Endpoint paths are added to this base URL.
How do I authenticate with the Azure Database for MySQL: Openapi?
With OAuth 2.0 (implicit flow) with 1 scope.
How many endpoints does the Azure Database for MySQL: Openapi have?
64 operations on 46 paths (31 GET, 15 POST, 9 PUT, 5 DELETE, 4 PATCH). The largest groups are Servers, Configurations, AdvancedThreatProtectionSettings, AzureADAdministrators.
Is forking the Azure Database for MySQL: Openapi free?
Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.