The Relational Database Service (RDS) is a managed database service provided by Amazon Web Services (AWS). It allows you to set up, operate, and scale a relational database in the cloud easily. RDS takes care of administrative tasks, such as hardware provisioning, database setup, patching, backups, and automated software updates, allowing you to focus on your applications and data.
<h2 id="heading-task-01">Task-01</h2>
<ul>
<li>Create a Free tier RDS instance of MySQL
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687170629558/2ceb7180-3875-47e4-8621-671d6e8c5df7.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687170674441/ae7c5395-0a2b-41d4-8175-103501b85bc6.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687170701558/7e0d12ae-25f0-4d4b-89b5-89de0511d67f.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687170731795/3e3d24e0-b733-4c3d-b56e-050ac432f91b.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687170768682/8255b613-58c3-4a01-bd21-fc5d598cef64.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687170852169/663e18a8-b32e-4395-a4cd-f6df0d3b7ac3.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687170892147/e2522e52-e6d8-4341-8425-da1a63ec4bd3.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687170954110/3099b906-9d67-4e1e-b9af-a6e3dde717a3.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687171012456/89adda2d-b15f-465b-a531-3ff17f847891.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687171034919/0ea4671f-a519-4435-bc75-e5f58720ef1b.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687171568749/5df75846-6664-405b-84c1-0b075eb0ba3e.png" alt class="image--center mx-auto" />
</li>
<li>Create an EC2 instance
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687171722613/98880981-4b41-4cc4-bf7a-8572a4b90494.png" alt class="image--center mx-auto" />
</li>
<li>Create an IAM role with RDS access
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687172329143/8d828e0e-e9c3-47f9-b614-8065b9f94df0.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687172367242/f376c874-da6d-4681-bf68-db04062ee88a.png" alt class="image--center mx-auto" />
</li>
<li>Assign the role to EC2 so that your EC2 Instance can connect with RDS
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687172429083/9768dab5-c06b-4e86-8b32-83467e363795.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687172454932/0bb8c35b-c441-4032-ad98-e34c6698fe9b.png" alt class="image--center mx-auto" />
<ul>
<li>Once the RDS instance is up and running, get the credentials and connect your EC2 instance using a MySQL client.</li>
</ul>
</li>
</ul>
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687176871721/5e1ef314-c3b9-44c7-8329-a1ed9ec2ccfc.png" alt class="image--center mx-auto" />
 <img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1687176846823/66f4cf0d-8cdc-45df-b5d7-6c3b1b88a55b.png" alt class="image--center mx-auto" />
Watch <a target="_blank" href="https://youtu.be/MrA6Rk1Y82E">this video</a> for reference.
Happy Learning
Mohammed Muqafamuddin

The Relational Database Service (RDS) is a managed database service provided by Amazon Web Services (AWS). It allows you to set up, operate, and scale a relational database in the cloud easily. RDS takes care of administrative tasks, such as hardware provisioning, database setup, patching, backups, and automated software updates, allowing you to focus on your applications and data.

## Task-01

* Create a Free tier RDS instance of MySQL
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687170629558/2ceb7180-3875-47e4-8621-671d6e8c5df7.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687170674441/ae7c5395-0a2b-41d4-8175-103501b85bc6.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687170701558/7e0d12ae-25f0-4d4b-89b5-89de0511d67f.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687170731795/3e3d24e0-b733-4c3d-b56e-050ac432f91b.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687170768682/8255b613-58c3-4a01-bd21-fc5d598cef64.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687170852169/663e18a8-b32e-4395-a4cd-f6df0d3b7ac3.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687170892147/e2522e52-e6d8-4341-8425-da1a63ec4bd3.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687170954110/3099b906-9d67-4e1e-b9af-a6e3dde717a3.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687171012456/89adda2d-b15f-465b-a531-3ff17f847891.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687171034919/0ea4671f-a519-4435-bc75-e5f58720ef1b.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687171568749/5df75846-6664-405b-84c1-0b075eb0ba3e.png align="center")
    
* Create an EC2 instance
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687171722613/98880981-4b41-4cc4-bf7a-8572a4b90494.png align="center")
    
* Create an IAM role with RDS access
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687172329143/8d828e0e-e9c3-47f9-b614-8065b9f94df0.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687172367242/f376c874-da6d-4681-bf68-db04062ee88a.png align="center")
    
* Assign the role to EC2 so that your EC2 Instance can connect with RDS
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687172429083/9768dab5-c06b-4e86-8b32-83467e363795.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687172454932/0bb8c35b-c441-4032-ad98-e34c6698fe9b.png align="center")
    
    * Once the RDS instance is up and running, get the credentials and connect your EC2 instance using a MySQL client.
        
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687176871721/5e1ef314-c3b9-44c7-8329-a1ed9ec2ccfc.png align="center")
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1687176846823/66f4cf0d-8cdc-45df-b5d7-6c3b1b88a55b.png align="center")
    

Watch [this video](https://youtu.be/MrA6Rk1Y82E) for reference.

Happy Learning

Mohammed Muqafamuddin

Day 44: Relational Database Service in AWS

Task-01