Updated on 2024-06-07 GMT+08:00

Resetting a Password for a Database Account

Function

This API is used to reset a password for a database account.

  • Before calling an API, you need to understand the API in Authentication.

Constraints

The password of a database account cannot be reset if the DB instance is in any of the following statuses: creating, changing instance class, changing port, rebooting, frozen, or abnormal.

URI

  • URI format

    POST /v3/{project_id}/instances/{instance_id}/db_user/resetpwd

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Project ID of a tenant in a region.

    For details about how to obtain the project ID, see Obtaining a Project ID.

    instance_id

    Yes

    Specifies the DB instance ID.

Request

Table 2 Parameter description

Name

Mandatory

Type

Description

name

Yes

String

Specifies the username of the database account.

password

Yes

String

Specifies the password of the database account.

Valid value:

The parameter must be 8 to 32 characters long and contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#%^*-_=+?,). The value cannot contain the username or the username spelled backwards.

You are advised to enter a strong password to improve security, preventing security risks such as brute force cracking.

Example Request

Reset the password of rds.
POST https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/f569f1358436479dbcba8603c32cc4aein03/db_user/resetpwd

{
    "name": "rds",
    "password": "****"
}

Response

  • Normal response
    Table 3 Parameter description

    Name

    Type

    Description

    resp

    String

    Returns successful if the invoking is successful.

Status Code

Error Code

For details, see Error Codes.