mysqldatabaseamazon-web-servicesamazon-rds
AWS: can't connect to RDS database from my machine
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.
Solution
It turns out it is not that hard. Do these steps:
- Go to EC2 Dashboard
- Go to Security Groups tab
- Select and only select the RDS database security group. You'll see the security group detail at the bottom
- Click Inbound tab
- Click Edit button
- Add Type:MYSQL/Aurora;Protocol:TCP;Range:3306;Source:0.0.0.0/0
- Where is MySQL's my.ini located on Windows?
- How to download Mysql jdbc jar file on centos
- pymysql.err.OperationalError: 1054. "Unknown column 'X' in 'where clause'
- What is the difference between utf8mb4 and utf8 charsets in MySQL?
- How to make a field NULL using MySQL GUI Tools?
- Renaming foreign-key columns in MySQL
- Fetch dates within the next 5 days from today, from a column of dates
- the MySQL service on local computer started and then stopped
- Using TABLE keyword to SELECT everything from vs SELECT * from table_name
- Importing CSV using MySQL Workbench. Not all records imported
- Mysql Pivot View
- unknown variable 'default-authentication-plugin=mysql_native_password'
- How to select a column with max value of other column, and all corresponding rows of column in another table?
- Trying to update a table using a trigger in mysql
- error column cannot be null, trying to upload file into sql
- Docker - mysqld: Table 'mysql.plugin' doesn't exist
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 54
- How can I check (My)SQL statements for syntactical correctness
- Automate mysql_secure_installation with echo command via a shell script
- need some explanation about MySQL where ... in ... subquery
- Show values from a MySQL database table inside a HTML table on a webpage
- UTF-8 all the way through
- How to load multiline csv feature into MySQL
- What are Visible INDEX and Invisible INDEX in MySQL? Which is better?
- MySQL Error Even Purging and Reinstalling does not fix it
- Problems using MySQL with AWS Lambda in Python
- How to know relations between tables
- How to increase MySQL connections(max_connections)?
- Mysqldump without triggers : ERROR 1359 (HY000) at line 1420: Trigger already exists
- PHP, mysql_query just NOT working