Microsoft Azure

Azure Database for MySQL (2017-12-01)

The Microsoft Azure management API provides create, read, update, and delete functionality for Azure MySQL resources including servers, databases, firewall…

Data & analytics#openapi

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 34

Servers

  • GETServers_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverNameGets information about a server.
  • PUTServers_Create/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/: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/servers/:serverNameDeletes a server.
  • PATCHServers_Update/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverNameUpdates an existing server. The request body can contain one to many of the properties present in the normal server definition.
  • GETServers_ListByResourceGroup/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/serversList all the servers in a given resource group.
  • GETServers_List/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/serversList all the servers in a given subscription.

ServerRestart

  • POSTServers_Restart/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/restartRestarts a server.

Replicas

  • GETReplicas_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/replicasList all the replicas for a given server.

FirewallRules

  • GETFirewallRules_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/firewallRules/:firewallRuleNameGets information about a server firewall rule.
  • PUTFirewallRules_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/firewallRules/:firewallRuleNameCreates a new firewall rule or updates an existing firewall rule.
  • DELETEFirewallRules_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/firewallRules/:firewallRuleNameDeletes a server firewall rule.
  • GETFirewallRules_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/firewallRulesList all the firewall rules in a given server.

VirtualNetworkRules

  • GETVirtualNetworkRules_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/virtualNetworkRules/:virtualNetworkRuleNameGets a virtual network rule.
  • PUTVirtualNetworkRules_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/virtualNetworkRules/:virtualNetworkRuleNameCreates or updates an existing virtual network rule.
  • DELETEVirtualNetworkRules_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/virtualNetworkRules/:virtualNetworkRuleNameDeletes the virtual network rule with the given name.
  • GETVirtualNetworkRules_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/virtualNetworkRulesGets a list of virtual network rules in a server.

Databases

  • GETDatabases_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/databases/:databaseNameGets information about a database.
  • PUTDatabases_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/databases/:databaseNameCreates a new database or updates an existing database.
  • DELETEDatabases_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/databases/:databaseNameDeletes a database.
  • GETDatabases_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/databasesList all the databases in a given server.

Configurations

  • GETConfigurations_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/configurations/:configurationNameGets information about a configuration of server.
  • PUTConfigurations_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/configurations/:configurationNameUpdates a configuration of a server.
  • GETConfigurations_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/configurationsList all the configurations in a given server.

ConfigurationsUpdate

  • POSTServerParameters_ListUpdateConfigurations/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/updateConfigurationsUpdate a list of configurations in a given server.

LogFiles

  • GETLogFiles_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/logFilesList all the log files in a given server.

ServerAdministrators

  • GETServerAdministrators_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/administrators/activeDirectoryGets information about a AAD server administrator.
  • PUTServerAdministrators_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/administrators/activeDirectoryCreates or update active directory administrator on an existing server. The update action will overwrite the existing administrator.
  • DELETEServerAdministrators_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/administrators/activeDirectoryDeletes server active directory administrator.
  • GETServerAdministrators_List/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/administratorsReturns a list of server Administrators.

RecoverableServers

  • GETRecoverableServers_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/recoverableServersGets a recoverable MySQL Server.

ServerBasedPerformanceTier

  • GETServerBasedPerformanceTier_List/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/performanceTiersList all the performance tiers for a MySQL server.

LocationBasedPerformanceTier

  • GETLocationBasedPerformanceTier_List/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/locations/:locationName/performanceTiersList all the performance tiers at specified location in a given subscription.

CheckNameAvailability

  • POSTCheckNameAvailability_Execute/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/checkNameAvailabilityCheck the availability of name for resource

Operations

  • GETOperations_List/providers/Microsoft.DBforMySQL/operationsLists all of the available REST API operations.

API details

Base URL
https://management.azure.com
Authentication
OAuth 2.0 (implicit flow) with 1 scope
Operations
34 operations on 22 pathsGET 19PUT 6DELETE 5POST 3PATCH 1
Main resources
Servers 6Databases 4FirewallRules 4ServerAdministrators 4VirtualNetworkRules 4Configurations 3CheckNameAvailability 1ConfigurationsUpdate 1LocationBasedPerformanceTier 1LogFiles 1
Response formats
application/json
Description format
Swagger 2.0, API version 2017-12-01

How to test the Azure Database for MySQL (2017-12-01) in Swastik Codes

  1. Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
  2. Fork it into your workspaceChoose a workspace. You get your own copy of the Azure Database for MySQL (2017-12-01) collection, without the publisher's secrets.
  3. 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.
  4. Send a requestPick an endpoint, for example “Servers_Get” (GET /subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName), 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 (2017-12-01)?

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 34 endpoints.

Who publishes the Azure Database for MySQL (2017-12-01)?

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 (2017-12-01)?

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 (2017-12-01)?

With OAuth 2.0 (implicit flow) with 1 scope.

How many endpoints does the Azure Database for MySQL (2017-12-01) have?

34 operations on 22 paths (19 GET, 6 PUT, 5 DELETE, 3 POST, 1 PATCH). The largest groups are Servers, Databases, FirewallRules, ServerAdministrators.

Is forking the Azure Database for MySQL (2017-12-01) free?

Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.

Suggest an API

Tell us which public API is missing. We check it, then add it here with its endpoints when it has an OpenAPI (Swagger) description.