Resetting a Password

GaussDB(DWS) allows you to reset the password of the database administrator. If a database administrator forgets their password or the account is locked because the number of consecutive incorrect password attempts reaches the upper limit, the database administrator can reset the password on the Clusters > Dedicated Clusters page. After the password is reset, the account can be automatically unlocked. You can set the maximum number of incorrect password attempts (10 by default) by configuring the failed_login_attempts parameter on the Parameter page of the cluster. For details, see Modifying Database Parameters.

Resetting a Password

  1. Log in to the GaussDB(DWS) management console.

  2. Choose Clusters > Dedicated Cluster.

  3. In the Operation column of the target cluster, choose More > Reset Password.

  4. On the displayed Reset Password page, set a new password, confirm the password, and then click OK.

    The password complexity requirements are as follows:

    • Contains 12 to 32 characters.

    • Cannot be the username or the username spelled backwards.

    • Must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters (~!?,.:;_(){}[]/<>@#%^&*+|\=-)

    • Passes the weak password check.

    • The new password must be different from the old password, or old password spelled backwards.

    • Previous passwords cannot be used repeatedly.

    Note

    If the default database administrator account of the cluster is deleted or renamed, password resetting fails.