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.