I have a public RDS mysql that I can access locally from my pc. When I try to login to an EC2 on a different account than the RDS, I cannot access it using mysql client or utilities. The EC2 has an elastic IP and the IP is in the RDS security group port 3306. Strange that I can access it from my local pc but not from another Aws account EC2 instance.

btw, I did try to find answers to this before posting but couldnt find anything.

  • Have you tried the internal IP instead of the external IP of the connecting instance?
    – ceejayoz
    Jul 10 '17 at 19:00
  • @ceejayoz - The Ec2 wouldn't know about the RDS's internal ip...its in a different Aws acount, Vpc, etc
    – chdev77
    Jul 10 '17 at 19:03

I figured it out. I had to add a new route for the RDS's VPC and set the route target to the gateway.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.