Microsoft Azure

MySQLManagementClient

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

Developer tools#openapi#cloud

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 33

Operations

  • GETOperations_List/providers/Microsoft.DBforMySQL/operations?api-version=stringLists all of the available REST API operations.

CheckNameAvailability

  • POSTCheckNameAvailability_Execute/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/checkNameAvailability?api-version=stringCheck the availability of name for resource

LocationBasedPerformanceTier

  • GETLocationBasedPerformanceTier_List/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/locations/:locationName/performanceTiers?api-version=stringList all the performance tiers at specified location in a given subscription.

Servers

  • GETServers_List/subscriptions/:subscriptionId/providers/Microsoft.DBforMySQL/servers?api-version=stringList all the servers in a given subscription.
  • GETServers_ListByResourceGroup/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers?api-version=stringList all the servers in a given resource group.
  • GETServers_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName?api-version=stringGets information about a server.
  • PUTServers_Create/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName?api-version=stringCreates 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/:serverName?api-version=stringDeletes a server.
  • PATCHServers_Update/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName?api-version=stringUpdates an existing server. The request body can contain one to many of the properties present in the normal server definition.

ServerAdministrators

  • GETServerAdministrators_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/Administrators/activeDirectory?api-version=stringGets information about a AAD server administrator.
  • PUTServerAdministrators_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/Administrators/activeDirectory?api-version=stringCreates 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/activeDirectory?api-version=stringDeletes AAD Administrator.
  • GETServerAdministrators_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/administrators?api-version=stringReturns a list of server Administrators.

Configurations

  • GETConfigurations_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/configurations?api-version=stringList all the configurations in a given server.
  • GETConfigurations_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/configurations/:configurationName?api-version=stringGets information about a configuration of server.
  • PUTConfigurations_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/configurations/:configurationName?api-version=stringUpdates a configuration of a server.

Databases

  • GETDatabases_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/databases?api-version=stringList all the databases in a given server.
  • GETDatabases_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/databases/:databaseName?api-version=stringGets information about a database.
  • PUTDatabases_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/databases/:databaseName?api-version=stringCreates a new database or updates an existing database.
  • DELETEDatabases_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/databases/:databaseName?api-version=stringDeletes a database.

FirewallRules

  • GETFirewallRules_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/firewallRules?api-version=stringList all the firewall rules in a given server.
  • GETFirewallRules_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/firewallRules/:firewallRuleName?api-version=stringGets information about a server firewall rule.
  • PUTFirewallRules_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/firewallRules/:firewallRuleName?api-version=stringCreates a new firewall rule or updates an existing firewall rule.
  • DELETEFirewallRules_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/firewallRules/:firewallRuleName?api-version=stringDeletes a server firewall rule.

LogFiles

  • GETLogFiles_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/logFiles?api-version=stringList all the log files in a given server.

Replicas

  • GETReplicas_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/replicas?api-version=stringList all the replicas for a given server.

ServerRestart

  • POSTServers_Restart/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/restart?api-version=stringRestarts a server.

ServerSecurityAlertPolicies

  • GETServerSecurityAlertPolicies_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/securityAlertPolicies/:securityAlertPolicyName?api-version=stringGet a server's security alert policy.
  • PUTServerSecurityAlertPolicies_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/securityAlertPolicies/:securityAlertPolicyName?api-version=stringCreates or updates a threat detection policy.

VirtualNetworkRules

  • GETVirtualNetworkRules_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/virtualNetworkRules?api-version=stringGets a list of virtual network rules in a server.
  • GETVirtualNetworkRules_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/virtualNetworkRules/:virtualNetworkRuleName?api-version=stringGets a virtual network rule.
  • PUTVirtualNetworkRules_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/virtualNetworkRules/:virtualNetworkRuleName?api-version=stringCreates or updates an existing virtual network rule.
  • DELETEVirtualNetworkRules_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/virtualNetworkRules/:virtualNetworkRuleName?api-version=stringDeletes the virtual network rule with the given name.

API details

Base URL
https://management.azure.com
Authentication
OAuth 2.0 (implicit flow) with 1 scope
Operations
33 operations on 20 pathsGET 18PUT 7DELETE 5POST 2PATCH 1
Main resources
Servers 6Databases 4FirewallRules 4ServerAdministrators 4VirtualNetworkRules 4Configurations 3ServerSecurityAlertPolicies 2CheckNameAvailability 1LocationBasedPerformanceTier 1LogFiles 1
Response formats
application/json
Description format
Swagger 2.0, API version 2017-12-01-preview
Listed from
APIs.guru OpenAPI Directory (CC0-1.0)
Source updated

How to test the MySQLManagementClient 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 MySQLManagementClient 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 “Operations_List” (GET /providers/Microsoft.DBforMySQL/operations?api-version=string), and press Send. Check the response, add tests and run the whole collection with the runner.

Frequently asked questions

What is the MySQLManagementClient?

The Microsoft Azure management API provides create, read, update, and delete functionality for Azure MySQL resources including servers, databases, firewall… It is listed under Developer tools and has 33 endpoints.

Who publishes the MySQLManagementClient?

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 MySQLManagementClient?

Requests go to https://management.azure.com. Endpoint paths are added to this base URL.

How do I authenticate with the MySQLManagementClient?

With OAuth 2.0 (implicit flow) with 1 scope.

How many endpoints does the MySQLManagementClient have?

33 operations on 20 paths (18 GET, 7 PUT, 5 DELETE, 2 POST, 1 PATCH). The largest groups are Servers, Databases, FirewallRules, ServerAdministrators.

Is forking the MySQLManagementClient 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.