Updated on 2025-09-04 GMT+08:00

Resetting the Password for User root

Function

This API is used to reset the password if you forget the password of your database account when using RDS. If there is a problem with the root account, for example, if your root account credentials are lost or deleted, you can reset the root password to restore access.

Before calling this API, learn how to authenticate it.
Before calling this API, learn about request header parameters.

Constraints

The password cannot be reset if the DB instance is in any of the following statuses: creating, rebooting, upgrading, changing instance class, creating users, or deleting users.

URI

URI format
POST /v3/{project_id}/instances/{instance_id}/password

Parameter description

**Table 1** Parameters
Parameter	Mandatory	Description
project_id	Yes	Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID.
instance_id	Yes	Specifies the DB instance ID.

Request

**Table 2** Parameters
Parameter	Mandatory	Type	Description
db_user_pwd	Yes	String	Specifies the database password. Valid value: The value 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 (~!@#$%^*-_=+?,()&). You are advised to enter a strong password to improve security, preventing security risks such as brute force cracking.

Example Request

Reset the password for user root.

{
     "db_user_pwd": "******"
}

Response

Normal response
None

Example normal response
```
{}
```
Abnormal response
For details, see Abnormal Request Results.

Status Code

Normal
200
Abnormal
For details, see Status Codes.

Error Code

For details, see Error Codes.

Parent Topic: Database and Account Management (MySQL)