Help Center> GaussDB> User Guide> Data Security> Resetting the Administrator Password
View PDF

Resetting the Administrator Password

Scenarios

You can reset the administrator password of a DB instance.

You can also reset the password of your database account when using GaussDB(for MySQL).

If an error occurs on the root account, for example, the root account is lost or deleted, you can restore the root account rights through resetting the password.

You cannot reset the administrator password under the following circumstances:

  • Your account is frozen.
  • The database port is being changed.
  • The instance status is Creating, Restoring, Rebooting, Changing port, Changing instance class, Promoting to primary, or Abnormal.

Precautions

  • If you change the administrator password of a DB instance, the passwords of the read replicas associated with the DB instance are also changed accordingly.
  • The length of time it takes for the new password to take effect depends on the amount of service data currently being processed by the primary node.
  • To prevent brute force cracking and ensure system security, change your password periodically, such as every three or six months.

Method 1

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click GaussDB.
  4. On the Instance Management page, locate the target DB instance and choose More > Reset Password in the Operation column.
  5. If you have enabled the operation protection function, click Start verification in the Reset Password dialog box. On the displayed page, click Send Code, enter the obtained verification code, and click Verify.

    For details about how to enable operation protection, see the Identity and Access Management User Guide.

  6. Enter a new password and confirm the password.

    Keep this password secure. The system cannot retrieve it.

    The new password must consist of 8 to 32 characters and contain at least three of the following: uppercase letters, lowercase letters, digits, and special characters (~!@#%^*-_=+?,). Enter a strong password and periodically change it to improve security, preventing security risks such as brute force cracking.

    • To submit the new password, click OK.
    • To cancel the reset, click Cancel.

Method 2

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click GaussDB.
  4. On the Instance Management page, click the target DB instance. The Basic Information page is displayed.
  5. In the DB Instance Information area, click Reset Password in the Administrator field. In the displayed dialog box, enter a new password and confirm the password.

    Keep this password secure. The system cannot retrieve it.

    The new password must consist of 8 to 32 characters and contain at least three of the following: uppercase letters, lowercase letters, digits, and special characters (~!@#%^*-_=+?,). Enter a strong password and periodically change it to improve security, preventing security risks such as brute force cracking.

Parent topic: Data Security