how to create a Database using AWS console

the following steps would guide you on how to create a DATABASE using AWS console

Go to the RDS management console at https://console.aws.amazon.com/rds/ (you will be required to sign in)

In the search bar type the Amazon RDS.

In the left navigation, under Amazon RDS, click Databases

Click on Create database button on the right top of the screen

Under the Choose a database creation method card select the Standard create radio button (should be selected by

default)

Under the Engine options card select the radio button for MySQL

Under the Templates card click the Dev/Test radio button (Note - this is not production setting and is being selected for this

exercise only)

Under the Availability & durability card ensure the radio for Single DB instance is selected

Under the Settings card make the following changes -

a) For the DB instance identifier text field pick a DB instance name

b) Expand the Credentials Settings section (if not already expanded) choose Self managed under Credentials

management

c) For the Master username text field pick a username and a password

Under the Instance configuration card make the following changes -

a) Under DB instance class enable the button for Include previous generation classes

b) Select the radio button for Bustable classes (Includes t classes)

c) Ensure in the dropdown (just below the above radio button) db.t3.micro is displayed/selected

Under the Storage card make the following changes -

a) Select/confirm the Storage type to be General Purpose SSD (gp2)

b) The Allocated storage should be changed to 20GiB

c) Enable storage autoscaling checkbox should be unselected

Under the Connectivity card make the following changes -

a) For the Public access radio ensure No is selected

b) For the VPC security group select the Create new radio button

c) For the New VPC security group name, pick a name-

Under the Database authentication card ensure the radio button for Password authentication is selected (should be

selected by default)

Under the Monitoring card ensure the Enable Enhanced Monitoring is unchecked

Expand the Additional configuration card (if not already) and make the following changes -

a) For the Initial database name field pick a name

b) The checkbox for Enable automated backups should be unchecked

c) The checkbox for Enable encryption should be unchecked

d) The checkbox for Enable auto minor version upgrade should be unchecked

Click on the Create database button (the database will take about 10 minutes to get created, can get done sooner). Refresh

the database listing page after every 1 min to check if the process is complete (Status shows Available).

Do not proceed until you see the status is Available

Click on the DB Identifier (gl-rds) link and copy the Endpoint (which looks like gl-rds.somecharacters.us-east

1.rds.amazonaws.com) under Endpoint & Port into a text editor on your laptop.