Resetting the Administrator Password

Scenarios

If you forget the password of your database account when using GaussDB(for MySQL), you can reset the password.

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.

Procedure

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.

   Alternatively, click the instance name on the Instances page to go to the Basic Information page. In the DB Instance Information area, click Reset Password in the Administrator field.

5. In the displayed dialog box, enter and confirm the new password.

   The new password must:

   • Consist of 8 to 32 characters.
   • Contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#%^*-_=+?,()&$|.).
   • Comply with the values of validate_password parameters.

     To check the password-related parameters, click the instance name, choose Parameters in the navigation pane, and search for validate_password in the upper right corner of the page.

6. Click OK.
   

   Keep your password secure. The system cannot retrieve it if it is lost.