?? 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;