Resetting the Password for User root

Updated on 2024-01-12 GMT+08:00

View PDF

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 an API, you need to understand the API in Authentication.

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** Parameter description
Name	Mandatory	Description
project_id	Yes	Specifies the 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

Parameter description

**Table 2** Parameter description
Name	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

Resetting 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)

Previous topic: Revoking Permissions of a Database Account

Next topic: Database and Account Management (PostgreSQL)

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel