Help Center/ Relational Database Service/ User Guide (Kuala Lumpur Region)/ Working with RDS for SQL Server/ Data Security/ Resetting the Administrator Password
Updated on 2022-08-16 GMT+08:00
View PDF
Share

Resetting the Administrator Password

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 you have changed the administrator password of the primary DB instance, the administrator passwords of the standby DB instance and read replicas (if any) will also be changed accordingly.
  • The time required for the new password to take effect depends on the amount of service data currently being processed by the primary DB instance.
  • To protect against brute force hacking attempts and ensure system security, change your password periodically, such as every three or six months.

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 Relational Database Service. 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. Enter and confirm a new 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 types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#$%^*-_+?,). Enter a strong password and periodically change it for security reasons.
    • 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 Relational Database Service. 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. In the displayed dialog box, enter and confirm a new 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 types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#$%^*-_+?,). Enter a strong password and periodically change it for security reasons.
    • To submit the new password, click OK.
    • To cancel the reset operation, click Cancel.

Parent topic: Data Security