STEPS TO CREATE A RELATIONAL DATABASE SERVICE (RDS) FROM AWS

Login to your aws account.

Go to services and search for rds. You will be taken to a page as shown below:

 

You can start by clicking on the orange button "Create Database".

Now fill the page with the following options:

--Standard create

--Engine options as MYSQL

--version : mysql-5.7.31

--templates : free-tier(as per your choice you can change)

--Username and password of database can be auto-generated or typed manually.

--Keep record of master username and password for further login
into database.

--public access: NO

Other settings can be left as default 

Note: the Availability zone of your RDS and EC2 instance should be same

After this you can click on "create" button at the end of your page.

then wait for the rds to be available. The rds can take 5-10 minutes to be available, so wait patiently.

**Here RDS database setup is finally completed and endpoint or
database host has been provided by database instances.

**This endpoint URL will be used in configuring WordPress with
database from RDS. 

The security group of the rds should be as follows: