Help Center/ GaussDB/ User Guide/ Resetting the Administrator Password of a GaussDB Instance
Updated on 2025-02-17 GMT+08:00
View PDF
Share

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.
  • If you log in to the database as the root user, resetting the password may interrupt services. Exercise caution when performing this operation.

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.