Refer to the following guide to learn how to use IAM in the cloud\
<https://scribehow.com/shared/Creating_an_IAM_User_and_User_Group_in_AWS_Management_Console__hWNiiXlcRJKFqYZZEJD-cg>

Sign in to **AWS Management Console** as an **IAM User**

**Pre-requisite** - Ensure you have selected the AWS region closest to your location\
For this guide, we will be using us-east-2 (Ohio) as a preferred choice

Type **RDS** in the search bar and click on **RDS** to view the RDS Dashboard

**What is Amazon RDS?**

Amazon RDS (Relational Database Service) is a cloud-based service offered by Amazon Web Services (AWS) that simplifies the setup, operation, and scaling of relational databases. It provides managed database solutions for popular database engines like MySQL, PostgreSQL, Oracle, SQL Server, and MariaDB, handling tasks such as provisioning, patching, backup, recovery, and scaling, allowing users to focus on their applications rather than database management.

On the **Amazon RDS** dashboard, click on the **Databases** from the left bar

**Databases** wizard will open, click on the DB identifier **mysqldatabase**

Refer to this guide to learn how to create an Amazon RDS Database\
<https://scribehow.com/shared/Creating_Your_First_RDS_Database_in_AWS__npccXKYTRse0Ba8bG3fncg>

**mysqldatabase** wizard will open, scroll the page and click on the **Connectivity & security** tab to view the Endpoint of the Database

Open the text editor and copy Endpoint, user, password and databasename from the **Connectivity & security** section

Type **EC2** in the search bar and click on **EC2** to view the EC2 Dashboard

**What is EC2 in AWS?**

Amazon EC2 (Elastic Compute Cloud) is a web service provided by Amazon Web Services (AWS) that offers resizable compute capacity in the cloud. It allows users to rent virtual servers, known as instances, and run their applications on them. EC2 instances can be easily scaled up or down to accommodate changing workload demands, and users only pay for the compute capacity they consume.

On the EC2 dashboard click on **Instances** from the left bar to view the EC2 instances

**Instances** wizard will open, select the **RDS Instance** instance

Refer to this guide to learn how to create an EC2 instance for RDS Database\
<https://scribehow.com/shared/Creating_an_EC2_instance_to_connect_to_RDS_Database__eVVBl7QmRFiYSohIAJ9KTw>

On the top right corner click on the **Connect** button

**Connect to instance** wizard will open, click on the **Connect** button

On the EC2 Instance Connect page type the command [[sudo yum update]]

**What is the sudo yum update command?**

"**Sudo yum update**" updates software packages on Linux systems using RPM Package Manager, granting administrative privileges with "sudo."

Type the command [[sudo su ]]to get the root user access

Type the command [[dnf -y install mysql mysql-community-client ]]to install mysql client

Amazon Web Services

This guide provides step-by-step instructions on how to connect to an RDS database from an EC2 instance and create tables.

Connecting to RDS Database from EC2 instance and creating tables