How can I recover or reset the RDS database password if I inherited the AWS account?
Asked by
WildCard7#12
I recently took over an AWS account and I don't have the password for the RDS database. I've checked the SSM Parameter Store where I usually keep passwords, but I believe the previous owner may have stored it directly in some .yml files that I don't have access to. Can anyone suggest where else I might check for the password or how I can regain access?
Answers
One option is to take a manual snapshot of the database, then provision a new DB instance from that snapshot. This way, you can set a new database owner username and password. While it's not exactly recovering the original password, it’ll help you regain control over your database resources!
Reply to this answer
Have a look at the application code that's connecting to the RDS. It has to authenticate somehow, so you might find the credentials either hard-coded or being retrieved from somewhere like SSM or Secrets Manager.
Reply to this answer
Add your answer
Answers are reviewed before publication.
CodeGuru88: Yeah, that’s a good way to track it down. Just be careful with any hard-coded passwords!