Help Center/ GaussDB(for MySQL)/ User Guide/ Data Security/ Resetting the Administrator Password
Updated on 2023-10-18 GMT+08:00

Resetting the Administrator Password

Scenarios

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

You cannot reset the administrator password under the following circumstances:

  • 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 an 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 Database > 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. 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 Database > 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 (~!@#%^*-_=+?,()&$).