AWS RDS Database show timeout error

Question

When accessing RDS from an EC2 instance that time show me timeout error

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Connection timed out in

i have try to specifying the IP address of the EC2 instance and specify the internal IP of the RDS instance but error is same.

can you show the connection string / url used to connect to RDS from ec2? — sanath meti, Dec 12 '17 at 13:20
$this->pdo = new PDO('mysql:host='.$this->host.';port='.$this->port.';dbname='.$this->database,$this->user,$this->passwd); — Hitesh Vala Ahir, Dec 12 '17 at 13:22
in RDS instance security group allow your ec2 ip in in-bound rules, and then first do a telnet to RDS port telnet RDS_URL 3306 — sanath meti, Dec 12 '17 at 13:26

score 3 · Answer 1 · answered Dec 12 '17 at 18:00

The most probable reason is that your RDS Security Groups are not configured to allow incoming traffic.

You need to change those security groups and allow inbound traffic.

Would recommend that inbound traffic's source IP's be limited to internal IP's of the EC2 instances from which you are hitting the RDS or for the CIDR block of the VPC/Subnet in which your EC2 instances are created.

AWS RDS Database show timeout error

1 Answers1

Linked