Resetting the Administrator Password

Scenarios

If you forget the password of your database account when using GaussDB(for MySQL), 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.

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 project.
3. Click in the upper left corner of the page and 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.

   Alternatively, reset the password using either of the following methods:

   • On the Instances page, click the instance name to go to the Basic Information page. In the upper right corner of the page, click Reset Password.
   • On the Instances page, click the instance name to go to the Basic Information page. Expand the Instance Information area and click Reset Password in the Configuration > Administrator field.

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. In the displayed dialog box, enter and confirm the new password.

   The new password must:

   • Consists 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 an instance name, choose Parameters in the navigation pane, and search for validate_password in the upper right corner of the page.

     Figure 1 Checking the password-related parameters
     

7. Click OK.
   

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