Cannot access Rds Aurora MySql after admin password change

Hi Fernando,

Please go through with the below documentation link and steps it will be helpful for you to resolve your issue.

https://repost.aws/knowledge-center/reset-master-user-password-rds https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-secrets-manager.html

Verify Password: Double-check the new admin password for correctness.

User Permissions: Ensure the admin username has the necessary permission.

Review Logs: Check the Logs & Events section in the AWS Management Console for any error messages or events related to the password change.

Reset Password: If necessary, reset the admin password again following AWS guidelines

In MySQL account names consist of a user name and a host name, this enables creation of distinct accounts for users with the same user name who connect from different hosts.

[+]https://dev.mysql.com/doc/refman/8.4/en/account-names.html

There are 3 users matching the master username; only resetting the the one not tied to a specific host

Above message means that you have 3 users with same name as your master-user but their host is different, When you reset master user password only the account with host "%" resets.

if you still have access the database using any other user please check the hosts you have configured for other 2 accounts with username same as master user from mysql.user table, if possible drop those accounts.

if you do not have access to the database using any other user, please try to access the database using master user credentials from a host that you have not configured for other two users.

Hope this helps!