How do you recover you RDS master user username?

Question

Resetting the RDS master user's password is simple enough, but how do you find your master users username?

score 38 · Answer 1 · answered Oct 20 '15 at 11:06

38

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!

answered Oct 20 '15 at 11:06

joakimcs

481
1
4
4

2

Nice 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 S Mar 29 '16 at 21:34
2

In 2017 update, the master user name is now under RDS > Instances > Connect > Master username – Raptor Oct 25 '17 at 03:47
13

As of right now, the master user name is under RDS > Instances > Configuration > Master username. – Captain Delano May 01 '19 at 14:54
I cannot find rds instance tab in my aws console. Can anyone share the instance url? – Sazzad Hissain Khan Mar 23 '20 at 05:52
7

In 2020, the master user name is now under RDS > Databases > Choose Desired Cluster or Database > Configuration > Master username – MillerMedia Jul 26 '20 at 04:50

score 37 · Accepted Answer · edited Nov 15 '20 at 20:40

37

The master user name can be recovered with the rds-describe-db-instances command.

If you are using aws cli-2, command shall become :

aws rds describe-db-instances --region ap-south-1

edited Nov 15 '20 at 20:40

Blaze

103
3

answered Apr 15 '12 at 20:11

Jan Fabry

836
1
10
18

1

The 2nd link is no longer working – Raptor Oct 25 '17 at 03:45
Good news, the second link works now. But the first doesn't. – simpleuser Feb 18 '19 at 21:26
the attribute from that JSON object is `MasterUsername` – Andre Leon Rangel Feb 23 '21 at 20:16

score 18 · Answer 3 · answered Apr 17 '19 at 07:18

18

It is 2019 now. It is 'Databases' on the sidebar, 'Configuration' on the navigation bar. And look for username.

answered Apr 17 '19 at 07:18

kklw

289
2
3

This is what worked, as of Nov 22, 2019 – Qasim Nov 22 '19 at 09:59
where can I get the password for the user? – Sazzad Hissain Khan Mar 23 '20 at 05:54

score 8 · Answer 4 · edited Jun 05 '18 at 01:59

8

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.

edited Jun 05 '18 at 01:59

Community

1

answered Dec 11 '17 at 18:00

Sai Phaninder Reddy J

181
1
3

In amazon aurora, it's under the "Configuration" tab – Savvas Radevic Nov 15 '19 at 08:39
I see no instance tab on my aws console – Sazzad Hissain Khan Mar 23 '20 at 05:51
For Amazon Aurora, it's in the "Configuration" tab of the cluster entry under "Availability". The label for it is "Master username". – jebeaudet Jun 05 '20 at 17:32

score 6 · Answer 5 · answered Jun 02 '18 at 19:45

6

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.

answered Jun 02 '18 at 19:45

arbabnazar

499
6
9

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-prod` because I wasn't sure what profile I had and it still worked as expected. – almel May 07 '20 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. – andrew lorien Oct 01 '20 at 04:33

score 2 · Answer 6 · answered Apr 27 '19 at 04:13

2

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

answered Apr 27 '19 at 04:13

systemBuilder

21
2

Only this method works for me! – khiav reoy Feb 11 '20 at 13:14

score 1 · Answer 7 · answered Oct 29 '19 at 06:17

1

Using AWS CLI to get all Instance names + the respective Master users:

aws rds describe-db-instances | grep -e \"DBInstanceId -e Master

answered Oct 29 '19 at 06:17

Lydon

11
2

score 0 · Answer 8 · edited Dec 17 '20 at 08:08

0

SELECT grantee 
FROM  sys.dba_role_privs 
WHERE granted_role='RDS_MASTER_ROLE' 
AND admin_option ='NO';

edited Dec 17 '20 at 08:08

John K. N.

1,955
1
16
26

answered Dec 03 '20 at 12:34

Volodymyr Merkulov

1
1

score 0 · Answer 9 · answered May 14 '22 at 20:42

0

TL;DR

Select the database and click top-right on modify

Here is the description how to do it:

The third field is the password.

answered May 14 '22 at 20:42

Timo

103
6

How do you recover you RDS master user username?

9 Answers9

TL;DR