Introduction to Amazon Relational Database Service (RDS) (Linux)

In this lab, I am creating a relational database service in Linux, I chose Linux because I deal so much in Windows that I want to be put out of my comfort zone.

The prerequisites for this lab is to have a PEM key which I already do I can continue on.

Creating a Relational Database Service (RDS) Instance

Creating an RDS is done in the RDS services tab.


I select a MYSQL database as this is what the lab instructed but also it provides a free tier.


In the production page, I select the DEV/Test as I will not actually be using this database for production.


I then need to specify the details of my database.


I then have to configure advanced settings, in here I set back up to 0 days as this disables automatic backup. I then Launch the DB instance.


I then have to edit the RDS Security groups to allow mysql client access. I done this by changing the source to anywhere.


Create an Amazon Linux Instance from an Amazon Machine Image (AMI)

I now need to setup a AWS Linux Instance which I will do now, the only settings I need to change is the tag, the rest stay default.


One the server is fully started I can then SSH into it using PuTTY.


Install MySQL client in your instance

Now I have SSH into my Instance I need to install MySQL via the terminal



MySQL is installed.


I know need to put the RDS endpoint into the terminal


I am now in MySQL database, I can verify this below.



Post Author: Techdox

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.