Help Center/ Data Warehouse Service/ User Guide/ DWS Cluster Management/ Resetting the Password of the DWS Database Administrator
Updated on 2026-08-24 GMT+08:00
View PDF
Share

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 Cluster > Cluster List page. The new password is applied immediately. By default, a maximum of 10 incorrect password attempts are allowed. You can change this number by setting the failed_login_attempts parameter 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 Cluster > Cluster List.
  3. Locate the target cluster, click More in the Operation column, and select Reset Password.

    Figure 1 Password resetting

  4. In the displayed Reset Password dialog box, set a new password, confirm the password, and then click OK. If the default database administrator account of the cluster has been deleted or renamed, password resetting fails.

    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.

Parent Topic: DWS Cluster Management