Create MySQL Database Instance with AWS RDS

The last blog post was MySQL related compared to the usual SQL Server. I might have some more MySQL related posts for variety, plus I’ve been working more with MySQL/AWS recently. With that in mind, I figured why not have a post devoted to setting up a simple MySQL instance in AWS RDS to test against.

From the Top

The first step is an easy one. We want to log into the AWS Management Console:

Let’s click into the search bar at the top and enter RDS. We’ll see it listed under Services. Let’s click that:

On the next screen we should have a button to Create database. We’ll click that button and get to the good stuff:

Let’s pick Standard create:

Next, we’ll have our engine options. Let’s choose MySQL and leave the version alone at 8.0.27.

For our template, let’s choose the Free tier:

I’m going to name the instance callihantest and set the master username to root. Feel free to auto generate a password or choose your own.

We’ll leave DB Instance Class and Storage alone;

And we’ll leave Availability and durability alone since we don’t need a standby instance:

Since we’re setting up a quick test and don’t intend to use any real data, we’ll set public access to Yes with the default VPC security group.

I’m going to keep it simple with Password authentication.

Finally, double check monthly costs (in this case it should be free) and click Create database.

We’ll wait a few minutes for callihantest to be created:

After a few minutes we’ll see that the work completed and callihantest is available for connections:

Now what?

In the next blog post we’ll take a look at logging into our new instance.

Thanks for reading!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s