Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

AWS: can't connect to RDS database from my machine

Tags:

database

mysql

django

amazon-web-services

amazon-rds

The EC2 instance/live web can connect just fine to the RDS database. But when I want to debug the code in my local machine, I can't connect to the database and got this error:

OperationalError: (2003, "Can't connect to MySQL server on 'aa9jliuygesv4w.c03i1 ck3o0us.us-east-1.rds.amazonaws.com' (10060)")

I've added .pem and .ppk keys to .ssh and I already configure EB CLI. I don't know what should I do anymore.

FYI: The app is in Django

like image 922
Aminah Nuraini Avatar asked May 13 '16 14:05

Aminah Nuraini

People also ask

How do I access AWS RDS database from local machine?

To connect to a private RDS DB instance from a local machine using an EC2 instance as a jump server, follow these steps: Launch and configure your EC2 instance and configure the network setting of the instance. Configure the RDS DB instance's security groups. Connect to the RDS DB instance from your local machine.

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.

Video Answer

1 Answers

It turns out it is not that hard. Do these steps:

  1. Go to EC2 Dashboard
  2. Go to Security Groups tab
  3. Select and only select the RDS database security group. You'll see the security group detail at the bottom
  4. Click Inbound tab
  5. Click Edit button
  6. Add Type:MYSQL/Aurora;Protocol:TCP;Range:3306;Source:0.0.0.0/0

Steps

like image 55
Aminah Nuraini Avatar answered Sep 28 '22 10:09

Aminah Nuraini
Sign in to Comment

Related questions

Postgres 9.1 vs Mysql 5.6 InnoDB?
DateTime group by date and hour
Search for string within text column in MySQL
Change output format for MySQL command line results to CSV
MySQL: get MAX or GREATEST of several columns, but with NULL fields
How do you write a conditional in a MySQL select statement?
MySQL stored procedures use them or not to use them
Retrieve last inserted id with Mysql
How to display a date as iso 8601 format with PHP
mysql server port number
MySQL arrange existing table columns
Pentaho Data Integration SQL connection
MySQL - How to count all rows per table in one query
ORDER BY date and time BEFORE GROUP BY name in mysql
How to change mysql to mysqli?
Can't import database through phpmyadmin file size too large
Laravel Migration table already exists, but I want to add new not the older
Moving connections and instances between two computers
Calculate age based on date of birth
How can I clear the screen in the MySQL console? [duplicate]

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!