Resetting a Password for an Account

Scenarios

You can reset passwords for the accounts you have created. To protect your DB instance against brute force cracking, change your password periodically, such as every three or six months.

Constraints

• This operation is not allowed when another operation is being performed on your DB instance.
• After the password is reset, the DB instance will not be rebooted and your permissions will not be changed.

• You can query password reset records on the CTS console. For details, see Cloud Trace Service User Guide.

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, click the instance name.
5. In the navigation pane, choose Accounts. On the displayed page, locate the target account and click Reset Password in the Operation column.
6. In the displayed dialog box, enter a new password, confirm it, and click OK.

   The password must meet the following requirements:

   • It must consist of 8 to 32 characters.
   • It must contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#$%^*-_=+?,()&|.).
   • It must comply with the values of validate_password parameters.
     To check the password-related parameter values, 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
     
   • The password you entered in the Confirm Password text box must be the same as that you entered in the New Password text box.
   • It cannot be the username or the username spelled backwards.

7. 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.

APIs

• Changing Password of a Database User
• Querying Database Users