Project Overview (What I Did)

In this project, I created and configured an RDS MySQL database and connected it with an EC2 instance. I installed the MySQL client on EC2, set up secure connectivity between EC2 and RDS using VPC security groups, created IAM roles, and performed SQL operations such as creating databases, tables, and inserting data.

1. Create an RDS Database Instance

Engine Selection

• Database engine: MySQL

• Full configuration mode

• Do NOT check “show only versions that support Multi-AZ DB cluster”

  (because Multi‑AZ is for production & costs more)

• Template: Free tier

• Availability: Single-AZ (1 instance)

  

Instance Settings

• Instance class: db.t3.micro
• Storage: 20 GB
• Default VPC
• Public access: No (private DB)
• Authentication: Password authentication

Click Create database

2. Launch and Prepare the EC2 Instance