I need to get an RDS in region X connected by Elastic Beanstalk from regions Y and Z. I have created RDS in a custom VPC. I need to connect to this RDS from my mac using MySQL Workbench.
For VPC, DNS Resolution and DNS Hostnames are set to Yes
For RDS, Publicaly accessible is set to Yes
Security group of RDS has opened connection to my IP address. But despite all these, I am not able to connect (error message: Failed to Connect).
For troubleshooting, I created an RDS with default VPC and I can easily connect to that instance.
Really appreciate if you can share your thoughts. Thanks