Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Unable to connect to Amazon web service mysql instance

I went through these instructions: http://docs.amazonwebservices.com/AmazonRDS/latest/GettingStartedGuide/

But still can't connect to the database using mysql from the command line.

I even tried: telnet xxxxxxx.clpkcufglfdn.us-east-1.rds.amazonaws.com 3306

but that doesn't connect either.

I did set up the DB security group using the CIDR suggested by the console (I hope it give me the right value).

Update: Firewalls are disabled on my end. It would be odd if amazon had firewalls on their end and wouldn't mention it in their documentation.

Update2: I'm behind a wireless router which had assigned my machine the IP of 10.0.0.2 so I tried adding that to the security groups but still can't connect.

like image 559
opike Avatar asked Mar 27 '11 01:03

opike


People also ask

Can't connect to MySQL server on Amazon RDS?

Troubleshoot database level issuesBe sure that you're using the correct user name and password to access the instance from your DB client. Be sure that the user has the database permissions to connect to the DB instance. Check for any resource throttling in Amazon RDS, such as CPU or memory contention.

How does AWS connect to MySQL database?

Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/ . In the navigation pane, choose Databases to display a list of your DB instances. Choose the name of the MySQL DB instance to display its details. On the Connectivity & security tab, copy the endpoint.

What are some of the common causes why you Cannot connect to a DB instance on AWS?

When you can't connect to a DB instance, the following are common causes: Inbound rules – The access rules enforced by your local firewall and the IP addresses authorized to access your DB instance might not match. The problem is most likely the inbound rules in your security group.


1 Answers

Update: Firewalls are disabled on my end. It would be odd if amazon had firewalls on their end and wouldn't mention it in their documentation.

Amazon's security groups are a firewall.

I did set up the DB security group using the CIDR suggested by the console (I hope it give me the right value).

If it's not the IP you're connecting from, it's not the right value.

like image 72
ceejayoz Avatar answered Oct 19 '22 11:10

ceejayoz