Connection denied using RDS proxy user different than master username

user_3962237 0
Viewed 267

I'm trying to set up a RDS proxy to serve mysql databases to my applications.

The most of the apps run with a username and password equals to master username set on RDS database, which have all grants.

I'm trying to access My RDS instance with a username and passwords different than master username and it gets "Connection denied using password (YES)"

this user have permissions to access only a mysql db.

I have searched the whole web to find the answer to this. How can I connect to RDS via Proxy using different users?

PS.: My RDS instance is using native authentication.

amazon-rds-proxy amazon-rds amazon-web-services
1 Answers

Try always use a Secret name that you can wildcard in the RDS policy like rds/prod/db_username

Review your RDS Proxy policy and wildcard de secretmanager resource like :

"arn:aws:secretsmanager:us-east-1:ACCOUNTNUMBER:secret:**rds/prod/***"
user_46425360
Related