Help Center/ GaussDB(DWS)/ FAQs/ Account Permissions/ How Do I Change the Password of a GaussDB(DWS) Database Account When It Expires?
Updated on 2025-07-22 GMT+08:00

How Do I Change the Password of a GaussDB(DWS) Database Account When It Expires?

Below are the methods for changing the password of a database account:

  • To change the password of user dbadmin, log in to the GaussDB(DWS) console, locate the target cluster and choose More > Reset Password in the Operation column.
    Figure 1 Resetting the password of user dbadmin
  • You can also connect to the database and run the ALTER USER command to change the password validity period of a database account (common user and administrator dbadmin).
    1
    ALTER USER username PASSWORD EXPIRATION 90;