CODEWITHSUNDEEP
mysqlapacheamazon-web-servicesnetwork-programmingtcp
user9541762
user9541762

Reputation:

Amazon Web Service RDS Connection Failure

I am trying to locally run a PHP based project, connecting to an Amazon RDS instance. I am receiving the following error in the browser:

![SQLSTATE[HY000] [2002]]1

I have run a series of networking tests where I pinged the following and received successful test results. I pinged:

I then tried the mysql utility to remotely connect and received the 

ERROR 2003 (HY000): Can't connect to MySQL server

enter image description here

Last factor I think you should know regarding my own networking situation, I am connecting to the internet via: 

modem->Zyxel VPN->Wireless Router->My laptop

What in the Sam Hill is going on? Thanks, CM

Upvotes: 0

Views: 173

Answers (1)

erik258
erik258

Reputation: 16275

For this to work, the following must be true:

  • the RDS instance must resolve to a public IP address (I'd check this for you but since you chose to use a screenshot instead of text, I can't copy paste it, so I'll leave it to you)

  • the Security Group(s) associated with the RDS instance must allow traffic from your public IP ( the one you'll get from http://wtfismyip.com/text ). This won't bet true by default. I highly recommend you open to your IP, not just everyone, as Mysql is trivial to DOS attack if its port is public.

  • The network ACL of the VPC hosting the RDS instance must allow the traffic also. This will be allowed by default, so unless you changed the ACLs in your VPC, you can ignore this.

If all those are true, you should be able to connect!

Upvotes: 1

Related Questions