7

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?

Sazzad Hissain Khan
  • 37,929
  • 33
  • 189
  • 256

2 Answers2

9

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.

Marcin
  • 215,873
  • 14
  • 235
  • 294
  • what's the password for root? – Sazzad Hissain Khan Mar 23 '20 at 09:36
  • Its the one when you setup your rds. – Marcin Mar 23 '20 at 10:15
  • 2
    I was doing a lab on RDS today. I created an MSSQL server using RDS and made an auto generated password. Later, I was unable to locate the password anywhere and the lab instructions also didn't guide the password retrieval method. So I had to modify the password manually in order to connect to the DB instance through Microsoft SQL Server Management Studio. Is there a way to retrieve the auto generated password? – Shubham Garg Mar 11 '23 at 19:22
2

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
Mark B
  • 183,023
  • 24
  • 297
  • 295
Mike
  • 20,010
  • 25
  • 97
  • 140
  • RDS does not use SecretsManager by default. This answer is incorrect, unless you have setup SecretsManager integration with RDS. – Mark B May 11 '23 at 14:59
  • You have to think about how your answer will help other people that land here looking for help. As it is, your answer is going to be really confusing to the 99% of people using RDS that haven't added the SecretsManager integration. If you edited your answer to say something like: "while not the default behavior of RDS, if you have added an integration with SecretsManager then you could find the password there" then it would be clear and not add to people's confusion. – Mark B May 11 '23 at 15:37