Resetting the RDS master user's password is simple enough, but how do you find your master users username?
The master user name can be recovered with the
If you are using aws cli-2, command shall become :
aws rds describe-db-instances --region ap-south-1
1The 2nd link is no longer working– RaptorOct 25, 2017 at 3:45
Good news, the second link works now. But the first doesn't. Feb 18, 2019 at 21:26
1the attribute from that JSON object is
MasterUsernameFeb 23, 2021 at 20:16
The master username is now listed in the RDS Dashboard.
- Select the "Instances" listing and expand the DB instance.
- Press the looking glass tab on the left.
- The master username is listed in the left column.
Hope this helps!
2Nice answer as it doesn't require the API. I might add that label/field name in the GUI is not 'Master User' but simply 'Username', which (as of this writing) currently appears under the 'DB Name'.– Andrew SMar 29, 2016 at 21:34
2In 2017 update, the master user name is now under RDS > Instances > Connect > Master username– RaptorOct 25, 2017 at 3:47
15As of right now, the master user name is under RDS > Instances > Configuration > Master username. May 1, 2019 at 14:54
I cannot find rds instance tab in my aws console. Can anyone share the instance url? Mar 23, 2020 at 5:52
7In 2020, the master user name is now under RDS > Databases > Choose Desired Cluster or Database > Configuration > Master username Jul 26, 2020 at 4:50
It is 2019 now. It is 'Databases' on the sidebar, 'Configuration' on the navigation bar. And look for username.
1This is what worked, as of Nov 22, 2019– QasimNov 22, 2019 at 9:59
where can I get the password for the user? Mar 23, 2020 at 5:54
With the new updated RDS UI, the username is present in the Details section of the Instance Information screen.
- From the List of your running Instances, click an instance name to see information about the instance.
- See the "Details" section of the information screen.
scroll down in that screen to see the "Details" section.
In amazon aurora, it's under the "Configuration" tab Nov 15, 2019 at 8:39
I see no instance tab on my aws console Mar 23, 2020 at 5:51
For Amazon Aurora, it's in the "Configuration" tab of the cluster entry under "Availability". The label for it is "Master username". Jun 5, 2020 at 17:32
Here is the command that you can use to get the master username of your RDS:
aws --profile=prod rds describe-db-instances --region us-east-1 --db-instance-identifier YOUR-RDS-IDENTIFIER-HERE --query 'DBInstances[*].MasterUsername'
Note: Replace the
prod with your aws profile and
YOUR-RDS-IDENTIFIER-HERE with your rds instance identifier
It will give you the master username like this:
[ "root" ]
Hope that might help future reader.
the above methods using the UI (including looking at the snapshot) did not work for me but this did. I didn't provide the
--profile-prodbecause I wasn't sure what profile I had and it still worked as expected.– almelMay 7, 2020 at 23:08
All of the answers that use the console become out of date so quickly (it's why i'm here today). The API will work for years. Do it this way everybody. Oct 1, 2020 at 4:33
I do not know how to directly find the aws admin username in 2019 AWS, however, you can see it in a snapshot. Just follow:
Main RDS console > Snapshots > A snapshot of your database > Details > Master username
Using AWS CLI to get all Instance names + the respective Master users:
aws rds describe-db-instances | grep -e \"DBInstanceId -e Master
SELECT grantee FROM sys.dba_role_privs WHERE granted_role='RDS_MASTER_ROLE' AND admin_option ='NO';
Select the database and click top-right on
Here is the description how to do it:
The third field is the password.