AWS: can't connect to RDS database from my machine
It turns out it is not that hard. Do these steps:
- Go to EC2 Dashboard
- Go to Security Groups tab
- Select and only select the RDS database security group. You'll see the security group detail at the bottom
- Click Inbound tab
- Click Edit button
- Add Type:MYSQL/Aurora;Protocol:TCP;Range:3306;Source:0.0.0.0/0
MAKE SURE PUBLIC ACCESSIBILITY IS SET TO YES
This is what I spent the last 3 days trying to solve...
Accept traffic from any IP address
After creating an RDS instance my security group inbound rule was set to a specific IP address. I had to edit inbound rules to allow access from any IP address.
- "Security group rules"
- Select a security group
- Click "Inbound Rules"
- Click "Edit Inbound Rules"
- Under "Source" Select the Dropdown and click "Anywhere"
- ::0 or 0.0.0.0/0 Should appear.
- Click "Save Rules"