I am trying to connect to an AWS RDS instance from an AWS EC2 instance. I ssh into the AWS EC2 instance, and then issue the following command:
mysql -h xxxxxx.ciy4oapkpytm.us-east-1.rds.amazonaws.com -P 3306 -u root -p
and when I enter my password, I get the following:
Access denied for user 'root'@'ip-10-xxx-xxx-50.ec2.internal' (using password: YES)
The ip address: 10.xxx.xxx.50 is already in my RDS instance security group.