CODEWITHSUNDEEP
databaseamazon-web-servicesamazon-s3rds
Sazzad Hissain Khan
Sazzad Hissain Khan

Reputation: 40245

How to get password of the Amazon aws rds user?

I can see there is a user from my aws rds console,

AWS Console -> RDS -> Databases -> Configuration -> Availability

But I forgot what was the password of this user? How can I see/ retrieve the password? Moreover how can I add new users for my existing database?

Upvotes: 11

Views: 50728

Answers (2)

Mykhaylo Adamovych
Mykhaylo Adamovych

Reputation: 20976

While not the default behavior of RDS, if you have configured an integration with Secrets Manager then you could find the password there.

Autogenerated passwords may be found within secrets

AWS Secrets Manager > Secrets > auroraDbSecret-G32dfhIgOda5

Upvotes: 5

Marcin
Marcin

Reputation: 238687

I think there is no way to recover the lost password, but you can Not sure you can recover, but you should be able to reset it.

Creating new uses is done from inside the db. You login as a root, and they you create new users with their passwords using db-specific sql statements for that. For instance for mysql you have CREATE USER statement.

Upvotes: 10

Related Questions