Help Center/ GaussDB/ FAQs/ Database Parameter Modification/ How Do I Set the Maximum Number of Failed Login Attempts for Accounts in GaussDB?
Updated on 2025-09-11 GMT+08:00

How Do I Set the Maximum Number of Failed Login Attempts for Accounts in GaussDB?

The failed_login_attempts parameter specifies the maximum number of incorrect password attempts before an account is locked. The account will be automatically unlocked after the time (in seconds) specified in password_lock_time elapses. You can set the maximum number of failed login attempts on the GaussDB console. Specifically, perform the following operations:

The locking and unlocking functions take effect only when the values of both password_lock_time and failed_login_attempts are positive numbers. For details about how to configure password_lock_time, see How Do I Set the Automatic Unlocking Time After an Account Is Locked in GaussDB?

  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, click the name of the target instance to go to the Basic Information page.
  5. In the navigation pane on the left, choose Parameters.
  6. Search for the failed_login_attempts parameter in the search box.
  7. Change the parameter value and click Save. The value ranges from 0 to 1000. The value 0 indicates that the number of incorrect password attempts is not limited.
  8. In the displayed dialog box, click OK.