Help Center> GaussDB(for MySQL)> User Guide> Data Security> Resetting the Administrator Password
Updated on 2024-05-21 GMT+08:00

Resetting the Administrator Password

Scenarios

If you forget the password of the administrator account, you can reset the password.

If an error occurs on the root account, for example, if your root account credentials are lost or deleted, you can restore the root account permissions 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 specifications, Promoting to primary, or Abnormal.

Precautions

  • If you have changed the administrator password of a DB instance, the passwords of the read replicas associated with the instance will also be changed accordingly.
  • The 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 protect against brute force hacking and improve system security, change your password periodically, such as every three or six months.
  • The instance may have been restored from a backup before you reset the administrator password.

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 in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
  4. On the Instances page, locate the instance for which you want to change the password and choose More > Reset Password in the Operation column.
  5. If you have enabled operation protection, click Start Verification in the displayed dialog box. On the displayed page, click Send Code, enter the obtained verification code, and click Verify to close the page.

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

  6. Enter a new password and confirm the password.

    Keep this password secure. If lost, 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 (~!@#%^*-_=+?,()&$).

    • 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 in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
  4. On the Instances page, click the instance name to go to the Basic Information page.
  5. In the DB Instance Information area, click Reset Password in the Administrator field. In the displayed dialog box, enter and confirm the new password.

    Keep this password secure. If lost, 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 (~!@#%^*-_=+?,()&$).