Help Center > > User Guide> Working with RDS for MySQL> Data Security> Resetting the Administrator Password to Restore Root Account Rights

Resetting the Administrator Password to Restore Root Account Rights

Updated at: May 26, 2020 GMT+08:00

Scenarios

You can reset the administrator password only through the primary DB instance.

You can also reset the password of your database account when using RDS.

If an error occurs on the root account, for example, the root account is lost or deleted, you can restore the root account rights 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 status of the primary DB instance is Creating, Restoring, Rebooting, Storage full, Changing port, or Abnormal.

Precautions

  • If you have changed the administrator password of the primary DB instance, the administrator passwords of the standby DB instance and read replica (if any) will also be changed accordingly.
  • The length of time it takes for the new password to take effect depends on the amount of service data currently being processed by the primary DB instance.
  • To prevent brute force cracking and ensure system security, change your password periodically.

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 Service List. Under Database, click RDS. The RDS console is displayed.
  4. On the Instance Management page, locate the target DB instance and choose More > Reset Password in the Operation column.
  5. If you have enabled the operation protection function, 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.

    Second authentication is required to improve the security of your account and cloud product. For details about how to enable operation protection, see the Identity and Access Management User Guide.

  6. Enter a new password and confirm the password.

    Figure 1 Resetting the administrator password

    Keep this password secure. 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 (~!@#%^*-_+?,). Enter a strong password and periodically change it to improve security, preventing security risks such as brute force cracking.
    • To submit the new password, click OK.
    • To cancel the reset operation, 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 Service List. Under Database, click RDS. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance.
  5. In the DB Information area on the Basic Information page, click Reset Password in the Administrator field.
  6. If you have enabled the operation protection function, 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.

    Second authentication is required to improve the security of your account and cloud product. For details about how to enable operation protection, see the Identity and Access Management User Guide.

  7. Enter a new password and confirm the password.

    Figure 2 Resetting the administrator password

    Keep this password secure. 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 (~!@#%^*-_+?,). Enter a strong password and periodically change it to improve security, preventing security risks such as brute force cracking.
    • To submit the new password, click OK.
    • To cancel the reset operation, click Cancel.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel