Week 3 (Mar 9-16, 2024): Database Problems!

Written By Isaac Wang

Encountering problems while setting up database!

I followed Amazon’s website tutorial “Create and Connect to a MySQL Database with Amazon RDS“. I was able to create an instance of a database on Amazon RDS but I had troubles connecting to it using SQL

Amazon’s website tutorial to create an instance of a database, then connect to it using MySQL

Opening Amazon RDS

 

To get past this problem, I started researching in depth about databases to build a stronger understanding of how Amazon RDS functioned. I focused on YouTube tutorials on Amazon RDS, as well as instructional blog posts I could find online. I learned that I needed to change some security settings so that the AWS database instance would trust connections coming from my network. With this change, I was able to connect to Amazon RDS using MySQL!

 

Next Steps

My next goals were to learn how to create tables in my newly made database to store user information in, and other data that my app would need to function properly.

Isaac Wang
Previous

Week 4 (Mar 16-23, 2024): Populating Database!
Next

Week 2 (Jan 14-21, 2024): Data Collection