I have imported a CentOS VM to EC2, it is running correctly. I created a MySQL RDS. They are both apparently in the same VPC.
From the shell in my VM I tried this command:
mysql -u root -h mydatabase-db2.cxyzzz85zzzz.eu-west-1.rds.amazonaws.com -p
When I enter the password I get this error:
ERROR 2005 (HY000): Unknown MySQL server host
'mydatabase-db2.cxyzzz85zzzz.eu-west-1.rds.amazonaws.com' (1)
DNS seems to work ok on my EC2 VM. Both EC2 and RDS are in the same VPC. I configured the RDS to be 'Publicly Available' when I created it. What else could I have missed?