Help Center> Relational Database Service> API Reference> API v3 (Recommended)> Database and Account Management (MySQL)> Resetting the Password for User root
Updated on 2024-06-07 GMT+08:00
View PDF

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 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.

This API is available to RDS for MySQL and RDS for PostgreSQL only.

URI

  • URI format

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

  • 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

db_user_pwd

Yes

String

Specifies the database password.

Valid value:

RDS for MySQL:

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 (~!@#$%^*-_=+?,()&).

RDS for PostgreSQL:

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. 
POST https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/password

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

Response

  • Normal response

    None

Status Code

Error Code

For details, see Error Codes.