4.2.7. Enable root user


Enables the root user for the specified database instance and returns the root password.

This operation enables login from any host for the root user and provides the user with a generated root password.

This table shows the possible response codes for this operation:

Response CodeNameDescription
200SuccessRequest succeeded.
400Bad RequestThe request is missing one or more elements, or the values of some elements are invalid.
401UnauthorizedYou are not authorized to complete this operation. This error can occur if the request is submitted with an invalid authentication token.
403ForbiddenYou are denied access to the requested resource.
404Not FoundThe requested item was not found.
405badMethodThe specified method is not allowed for the given resource.
413Over LimitThe number of items returned is above the allowed limit.
422unprocessableEntityThe item cannot be processed.
500instanceFaultThe instance has experienced a fault.
501notImplementedThe server does not support the functionality required to fulfill the request.
503Service UnavailableThe service is not available. Request

This table shows the URI parameters for the enable root user request:




The account ID of the owner of the specified instance.



The instance ID for the specified database instance.


Example 4.33. Enable root user: JSON request

The following example shows the Enable root user request:

POST /v1.0/1234/instances/d4603f69-ec7e-4e9b-803f-600b9205576f/root HTTP/1.1
User-Agent: python-troveclient
Host: ord.databases.api.rackspacecloud.com
X-Auth-Token: 87c6033c-9ff6-405f-943e-2deb73f278b7
Accept: application/json
Content-Type: application/json

This operation does not accept a request body. Response


Example 4.34. Enable root user: JSON response

The following example shows the Enable root user response:

HTTP/1.1 200 OK
Content-Type: application/json
Via: 1.1 Repose (Repose/2.6.7)
Content-Length: 47
Date: Thu, 13 Feb 2014 21:47:14 GMT
Server: Jetty(8.0.y.z-SNAPSHOT)

    "user": {
        "name": "root", 
        "password": "12345"

Contents Search
loading table of contents...