Resetting the Administrator Password of a GaussDB Instance

Scenarios

If you forget the password of your root account when using GaussDB, you can reset the password.

Precautions

• If the password you provide is regarded as a weak password by the system, you will be prompted to enter a stronger password.

• If the DB instance is abnormal, the administrator password cannot be reset.
• The volume of data being processed by the instance determines how long it takes for the new password to take effect.
• To prevent brute force cracking and ensure system security, change your password periodically.
• You cannot reset the administrator password when the account is frozen.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > GaussDB.
4. On the Instances page, locate the instance that you want to reset password for and click More > Reset Password in the Operation column.

   Alternatively, click the instance name to go to the Basic Information page. In the Basic Information area, click Reset Password next to the Administrator field.

5. Enter a new password and confirm the password.
   Figure 1 Resetting a password
   
   

   The new password must:

   • Contain 8 to 32 characters.
   • Contain at least three types of the following: uppercase letters, lowercase letters, digits, and special characters. Supported characters: ~!@#%^*-_=+?,
   • Be different from the old password or the old password written backwards.

6. If you have enabled operation protection, click Start Verification in the displayed dialog box. On the displayed page, click Send Code, enter the obtained verification code, and click Verify to close the page.

   Two-factor authentication improves the security of your account. For details about how to enable operation protection, see Identity and Access Management User Guide.