Help Center/ Data Warehouse Service/ Management Guide/ DWS Cluster Management/ Resetting the Password of the DWS Database Administrator
Updated on 2026-11-10 GMT+08:00

Resetting the Password of the DWS Database Administrator

If you forget the password of the administrator account root or lock the account, you can reset the password on the Dedicated Clusters > Clusters page. The new password is applied immediately. failed_login_attempts indicates the maximum number of incorrect password attempts. Its default value is 10 and you can change its value on the Parameter Modifications page of the cluster. For details, see Modifying GUC Parameters of the DWS Cluster.

Resetting a Password

  1. Log in to the DWS console.
  2. Choose Dedicated Clusters > Clusters.
  3. In the Operation column of the target cluster, choose More > Reset Password.
  4. On the displayed Reset Password dialog box, set a new password, confirm the password, and then click OK.

    The password:
    • Contains 12 to 32 characters.
    • Cannot be the username or the username spelled backwards.
    • Contains at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters (~!?,.:;_(){}[]/<>@#%^&*+|\=-)
    • Passes the weak password check.
    • Cannot be the same as the current password and cannot be the reverse of the current password.
    • Cannot use a historical password.

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