First thing first, I have checked almost all the answers related to this but couldn't find the cure to the problem.
To connect to RDS, I know that we need to set the inbound rules in the security group associated with the RDS instance to my machine's IP, which is already set.
Am just using a mysql
client like sequel pro
, specify the RDS endpoint, mention the username and pwd but everytime the connection could not be established.
There is no firewall as I am using my mobile internet by connecting my machine through hotspot.
One important thing that might be causing the issue could be the subnets that are associated with the default VPC
on my RDS
. I have 2 public subnets and 2 private subnets associated.
Also ran the command nc rds-host port
, even that also timed-out.
Tried all troubleshooting steps but still not able to connect. Could somebody throw some light here. Stuck for a very long time.
This is the error:
Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).
MySQL said: Can't connect to MySQL server on 'abcdef.rds.amazonaws.com' (4)