Changing the Password of a Database User

Changing the Password of a Database User

Function

This API is used to change the password of a database user

Constraints

This operation cannot be performed on frozen and abnormal instances.

URI

  • URI format

    PUT /v3/{project_id}/instances/{instance_id}/reset-password

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    instance_id

    Yes

    Specifies the DB instance ID.

Requests

  • Parameter description
    Table 2 Parameter description

    Name

    Mandatory

    Type

    Description

    user_name

    No

    String

    Specifies the database username. The default value is "rwuser".

    The value must be 1 to 64 characters and can contain only letters (from A to Z or from a to z), digits (from 0 to 9), hyphens (-), and dots (.).

    user_pwd

    Yes

    String

    Specifies the database password.

    • The value must be 8 to 32 characters in length and contain uppercase letters (A to Z), lowercase letters (a to z), digits (0 to 9), and special characters, such as ~!@#%^*-_=+?
    • You are advised to enter a strong password to improve security, preventing security risks such as brute force cracking.

    db_name

    No

    String

    Specifies the database where the user is located. The default value is "admin".

    The value must be 1 to 64 characters and can contain only letters (from A to Z or from a to z), digits (from 0 to 9), and underscores (_).

  • Request header
    PUT https://DDS endpoint/v3/{project_id}/instances/{instance_id}/reset-password
  • Example request
    {
    "user_name": "testUser",
    "user_pwd": "Test#%0_"
    }

Responses

  • Response example
    {}

Status Code

For more information, see Status Code.

Error Code

For more information, see Error Code.