🌟 Successfully Set Up Amazon RDS and EC2 Integration! 🚀

I recently accomplished a key task in my cloud learning journey by setting up an Amazon RDS instance and securely connecting it with an EC2 instance. Here’s a breakdown of the process I followed:

1️⃣ Created an RDS instance and configured the Security Group by allowing access from the EC2 instance's Security Group ID.

2️⃣ Launched an EC2 instance, updated the server, and installed the MySQL client.

Update and install MySQL client

sudo apt update
sudo apt install mysql-client -y        

3️⃣ Enabled MySQL/Aurora in the Security Group to allow inbound traffic.

4️⃣ Successfully connected to the MySQL database using the client installed on the EC2 instance.

Connect to the RDS instance

mysql -h <RDS_ENDPOINT> -P 3306 -u <USERNAME> -p        

5️⃣ Created a database named my_project_db to complete the setup.

Create a new database and verify the database

CREATE DATABASE my_project_db;
SHOW DATABASES;