Guys I had troubles with my EC2, I connected the EC2 through SSH successfully and used command line like “mysql -h **..rds.amazonaws.com (myRDS Endpoint) -p 3306 -u ** -p**” to connect to the RDS, unfortunately, I got this error after a while: "ERROR 2003 (HY000): Can't connect to MySql server on '**..rds.amazonaws.com' (110)'', there were several comments:
- This EC2 and RDS are in same region and same available zone (Tokyo).
- This EC2 is an classic one not VPC.
- I can connect to to this Tokyo RDS through an EC2 located in other region (Singapore).
- I get the same ERROR Info when using this Tokyo EC2 to connect to a RDS in Singapore and I'm sure Singapore RDS is available.
- I tried "nc -zv 3306" using Tokyo EC2, but got a "time out" error while it succeed when using Signore EC2 to do this.
- I checked the iptables of the Tokyo EC2, but there was no iptables there.
- So, I doubt the problem is the EC2 not the RDS.
- I google this and found the most similar questions are caused by SG, reason of this problem,
Very appreciated if any help, thanks in advance.
Best Regards
Beyond Wang
