Updated on 2024-04-03 GMT+08:00

Resetting a Password for a Database Account

Scenarios

You can reset passwords for the accounts you have created. To protect against brute force hacking attempts and ensure system security, change your password periodically, such as every three or six months.

Constraints

  • Passwords cannot be reset for DB instances that are in the process of being restored.
  • Databases and accounts created using other methods than the RDS console and APIs are also displayed on the RDS console. If the names of the created databases or accounts do not meet the database naming rule or account naming rule, for example, the names containing Chinese characters or unsupported special characters, the databases or accounts cannot be managed on the RDS console or through APIs.
  • If the name of any database or account on the source database does not meet the database naming rule or account naming rule, the database or account cannot be managed on the RDS console or through APIs after being migrated to the destination RDS for MySQL instance.

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 and choose Databases > Relational Database Service.
  4. On the Instances page, click the target DB instance.
  5. In the navigation pane on the left, choose Accounts. On the Accounts page, locate the target username and click Reset Password in the Operation column.
  6. In the displayed Reset Password dialog box, enter and confirm a new password, and click OK.

    Figure 1 Resetting a password

    • The password must consist of 8 to 32 characters and contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~ ! @ # $ % ^ * - _ = + ? , ( ) & . | ).
    • The password must be different from the username or username spelled backwards.
    • You are advised to enter a strong password to improve security and prevent security risks such as brute force cracking.
    • After the password is reset, the database will not be rebooted and permissions will not be changed.
    • You can query password reset records on the CTS console. For details, see the Cloud Trace Service User Guide.

  7. If you have enabled operation protection, click Send Code in the displayed Identity Verification dialog box and enter the obtained verification code. Then, click OK.

    Two-factor authentication improves the security of your account and cloud product. For details about how to enable operation protection, see the Identity and Access Management User Guide.