Unable to connect to MySQL AWS RDS instance from local MySQL

Question

I have created an MySQL RDS instance with VPC. Now i am trying to connect to that RDS instance from my Ubuntu 12.04 machine using MySQL client by following code:

mysql -u uname -h test.c6tjb4nxvlri.us-west-2.rds.amazonaws.com -P 3306 -p

But i am getting this error:

ERROR 2003 (HY000): Can't connect to MySQL server on 'test.c6tjb4nxvlri.us-west-2.rds.amazonaws.com' (110)

I searched about this error and everywhere solution came out like

• Go to the Instances
• Find the security group
• Change the inbound rules of that security group by
• Adding source of user machine public ip or
• Set source ip as 0.0.0.0/16

I tried everything but still same error occures. Any explanations?

Answer 1

The problem was in subnet. Subnet that you created must be publicly accessible.