As the question asked, I can’t connect to my RDS instance when executing the below command
mysql -h [hostname] -u root -P 3306 -p
It shows Error 10060 while trying to connect an amazon mysql rds
Refer below for my setup
Updated Security group setting
I tried every solution possible that I found on the damn google and not a single one works. 🙁
2
Answers
I’m assuming your infrastructure for your rds is something like this:
Taking that into account:
outbounds: https://docs.aws.amazon.com/vpc/latest/userguide/vpc-security-groups.html
And finally, check that the AWS firewall or any issue from your access to the network is not causing any inconvenience. You can achieve this either by using another device or by removing any VPN or proxy that you have associated.
Your RDS subnet group currently includes all 4 subnets: 2 public and 2 private. You need to include only the public subnets with Internet gateway routing. Please remove the private subnets and attempt to connect again.