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.