'Connection denied using RDS proxy user different than master username

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.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source