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.

rds.PNG

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

mysql.PNG

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

dev.PNG

I then need to specify the details of my database.

detz.PNG

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.

advanced.PNG

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

inbound.PNG

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.

awss.PNG

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

Puttyaa.PNG

Install MySQL client in your instance

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

mw.PNG

 

MySQL is installed.

rdss.PNG

I know need to put the RDS endpoint into the terminal

rdssssss.PNG

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

mysqlaa.PNG

 

%d bloggers like this: