How do I reset the master user password for my Amazon RDS DB instance?

Last updated: 2019-04-26

How do I reset the master user password for my Amazon Relational Database Service (Amazon RDS) DB instance?

Short Description

You can change the master user password for your Amazon RDS DB instance by using the Amazon RDS console.

For clustered systems, such as Amazon Aurora, reset the password for any instance in the cluster with a Writer or Reader role. Then, choose Apply Immediately. The password change applies asynchronously to the instance, as soon as possible, and doesn't require a restart.

Resolution

To modify the master user password, follow these steps:

  1. Open the Amazon RDS console.
  2. Select Databases
  3. Select the DB instance, and then choose Modify.
    Note: If you use Aurora, expand the cluster, and choose the instance that you want to modify. Then, choose Modify.
  4. Enter the master user password you want to use in the New Master Password field.
    Note: The change is applied asynchronously, as soon as possible, and this change ignores the Apply Immediately setting.
  5. Choose Continue, and then choose Modify DB Instance.

The Status field for your DB instance on the RDS dashboard changes to resetting-master-credentials. When the modification is complete, the Status column changes to Available. You can also modify a DB instance using the Amazon RDS API or the AWS Command Line Interface (AWS CLI).


Did this article help you?

Anything we could improve?


Need more help?