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)