Retrieve All MySQL Databases
Applies To: Windows Azure Pack
Retrieves a list the of MySQL databases for the specified subscription.
Replace <TenantAPI> with your Service Management API endpoint address. Replace <SubscriptionId> with the tenant subscription identifier.
Method | Request URI | HTTP version |
|---|---|---|
GET | https://<TenantAPI>:30005/<SubscriptionId>/services/mysqlservers/databases | HTTP/1.1 |
None.
The following table describes required and optional request headers.
Request header | Description |
|---|---|
Authorization: Bearer | Required. The authorization bearer token. |
x-ms-principal-id | Required. The principal identifier. |
x-ms-client-request-id | Optional. The client request identifier. |
x-ms-client-session-id | Optional. The client session identifier. |
x-ms-principal-liveid | Optional. The principal Live identifier. |
None.
The response includes an HTTP status code, a set of response headers, and a response body.
A successful operation returns status code 200 (Ok).
The response for this operation includes standard HTTP headers. All standard headers conform to the HTTP/1.1 protocol specification.
The following table describes the key elements of the response body:
Element name | Description |
|---|---|
MySqlDatabase | The retrieved list of databases. For more information, see MySqlDatabase (Object). |
The following code example shows a Retrieve All MySQL Databases request.
GET https://<TenantAPI>:30005/<SubscriptionId>/services/mysqlservers/databases HTTP/1.1 x-ms-version: 2012-03-01 Accept: application/json Authorization: Bearer <Token> x-ms-client-request-id: b74f6001-9b95-4e83-8bae-d098ec2501cb-2013-08-28 23:51:58Z x-ms-client-session-id: e046372b-5230-47b9-b98e-af0d9d627f78 x-ms-principal-id: abc%40contoso.com Accept-Language: es-ES Host: <TenantAPI>:30005 Connection: Keep-Alive
The following code example shows a Retrieve All MySQL Databases response.
[
{
"Name": "newdatabase",
"MySqlServerName": "<computer>",
"MySqlServerId": "lxbn7i",
"SubscriptionId": "9599bfe1-7a75-47ad-836b-97b80ea86103",
"ConnectionString": "Server=pt-cspod21;Database=newdatabase;User Id=newadmin;Password=<<Aqu\u00ed-va-la-contrase\u00f1a-de-su-base-de-datos>>",
"Edition": "Default",
"MaxSizeMB": 1024,
"Collation": "latin1_swedish_ci",
"CreationDate": "0001-01-01T00:00:00+00:00",
"ModifiedDate": "0001-01-01T00:00:00+00:00",
"Status": "1",
"AdminLogon": "newadmin",
"Password": "",
"Quota": "1024",
"AccountAdminId": null
}
]