# How to reset the RDS master password

How-to guides · Updated 16 November 2026

**Short answer:** You can't read an RDS master password back, but you can set a new one: in the RDS console choose Modify, enter a new master password and apply immediately, or run aws rds modify-db-instance --master-user-password with --apply-immediately (modify-db-cluster for Aurora). There's no reboot. Better still, let RDS manage it in Secrets Manager, after which you retrieve it with get-secret-value.

## Console steps

1. Open the Amazon RDS console, choose **Databases** and select the instance (for Aurora, select the *cluster*).
2. Choose **Modify**. In the settings section, enter a new master password, or select the option to manage the master credentials in AWS Secrets Manager.
3. Continue, choose **Apply immediately**, and confirm. The status shows `resetting-master-credentials` briefly, then returns to `available`.

## CLI steps

```
# RDS instance: set a new password (prompted, so it stays out of shell history)
read -rs NEWPW
aws rds modify-db-instance \
  --db-instance-identifier my-db \
  --master-user-password "$NEWPW" \
  --apply-immediately

# Aurora: the password belongs to the cluster
aws rds modify-db-cluster \
  --db-cluster-identifier my-aurora \
  --master-user-password "$NEWPW" \
  --apply-immediately
```

To hand the password to Secrets Manager instead (RDS generates and rotates it):

```
aws rds modify-db-instance --db-instance-identifier my-db \
  --manage-master-user-password --apply-immediately

# Later: find the secret and read it
SECRET_ARN=$(aws rds describe-db-instances --db-instance-identifier my-db \
  --query 'DBInstances[0].MasterUserSecret.SecretArn' --output text)
aws secretsmanager get-secret-value --secret-id "$SECRET_ARN" \
  --query SecretString --output text
```

## "aws cli get rds password": what is possible

If the password was set by hand, AWS doesn't store it in a form you can retrieve; no API returns it. Your options are to find it where your team keeps it (a secrets store, a CloudFormation parameter, an environment variable on the application) or to reset it. Once RDS manages the password in Secrets Manager, `get-secret-value` returns it, subject to IAM permissions on the secret and its KMS key.

For applications, IAM database authentication avoids long-lived passwords entirely for MySQL and PostgreSQL engines.

## Before and after

- **Before:** find every client using the master user. Changing the password breaks them at their next new connection; existing connections usually carry on until they reconnect.
- **Before:** if the instance is a read replica, change the password on the source; it replicates.
- **After:** update the secret your applications read, then test a fresh login (`psql` or `mysql` with the new password).
- **After:** check CloudTrail for the `ModifyDBInstance` event if you need an audit record; the password value is not logged.

## Common mistakes

- **Omitting `--apply-immediately`.** Without it, the change can wait for the maintenance window and you keep getting [password authentication failed](https://cloudconsole.dev/errors/rds-postgres-password-authentication-failed).
- **Modifying an Aurora instance instead of the cluster.** Master credentials are a cluster setting.
- **Using the master user for applications.** Create application users with only the privileges they need; reset the master password and keep it for administration.
- **Locked out after revoking master privileges.** Setting a new master password through RDS also restores the master user's standard privileges, which is the supported recovery route.

## Questions

### Does resetting the RDS master password cause downtime?

No reboot is required and the database stays available. Clients using the old password fail when they next authenticate.

### How do I change the RDS password for a user that isn't the master?

Connect as the master user and use the engine's own command, such as ALTER USER in PostgreSQL or MySQL. RDS APIs only manage the master user.

### Where do I find the master username?

aws rds describe-db-instances --db-instance-identifier my-db --query DBInstances[0].MasterUsername shows it; for Aurora use describe-db-clusters.

## When this happens away from your desk

Credential problems tend to surface as a wall of failed logins in an alert. CloudConsole, a phone app for AWS, is built to show database alarms and recent changes on your phone, with production guardrails.

[About the CloudConsole app](https://cloudconsole.dev/aws-console-app) · [Download on the App Store](https://apps.apple.com/app/cloudconsole-for-aws/id6835419710)

## Sources

- [Modifying an Amazon RDS DB instance](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.DBInstance.Modifying.html)
- [Password management with Amazon RDS and AWS Secrets Manager](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-secrets-manager.html)

## Related

- [aws rds modify-db-instance](https://cloudconsole.dev/cli/rds-modify-db-instance)
- [aws secretsmanager get-secret-value](https://cloudconsole.dev/cli/secretsmanager-get-secret-value)
- [FATAL: password authentication failed for user (RDS PostgreSQL)](https://cloudconsole.dev/errors/rds-postgres-password-authentication-failed)
- [ERROR 1045 (28000): Access denied for user on RDS MySQL](https://cloudconsole.dev/errors/rds-mysql-access-denied-for-user)
- [How to restore RDS from a snapshot](https://cloudconsole.dev/how-to/restore-rds-from-snapshot)
- [How to add my IP to an AWS security group](https://cloudconsole.dev/how-to/add-my-ip-to-security-group)

---

Source: https://cloudconsole.dev/how-to/reset-rds-master-password

CloudConsole is an independent iPhone and Android app for Amazon Web Services by Cloudconcur Ltd. It is not affiliated with Amazon Web Services.
