I am trying to connect my MySQL RDS from EC2. Under security groups I have made sure permissions are in place.
$ mysql -h xxx.xyz.ap-southeast-1.rds.amazonaws.com -P 3306 -p Enter password:
I am sure password is correct; because i reset it using AWS console. I am getting following error:
Access denied for user 'root'@'ip-xx-xxx-xxx-xxx.ap-southeast-1.compute.internal' (using password: YES)
I am 99% sure that Amazon RDS does not give you a ‘root’ access. i.e. You can’t create a user as ‘root’@’localhost’ or ‘root’@”.
Can you confirm user you have used while launching Amazon RDS instance? and make sure that Password matches with user created.
It looks like there is a bug in AWS console. Most likely you’ve provided a password with restricted characters for the master user. In this case, AWS console doesn’t prevent it, but you will never manage to connect to the database, even you’ll change a password (BTW here AWS console will not allow you to insert restricted characters). The only way to cope with this issue is the redefinition of a new RDS instance/cluster (Definitely you can try to resolve it with the AWS support team)
P.S. Even though it was reported many years ago, the bug still exists there))