AWS Create the MySQL DB Instance in RDS

As AWS offers 1-year free tier, let’s play with it.

Here I am going to show you how to create the MySQL DB and use the Navicat to connect it.

##Step 1

1. Go to Amazon RDS Dashboard, and click ‘Create database’.

2. Go through this image, step by step

3. Config Inbound

Go to Security Groups and select the one you choose below (during create DB).

Click ‘Inbound’ => ‘Edit’ => ‘Add Rule’ => ‘MYSQL/Aurora’ => ‘Source’ => ‘Anywhere’.

##Step 2

If you want to connect to it, there are three things you should have. Endpoint, username, password. Endpoint you can find it follow step 1.

1. Go to Amazon RDS Dashboard, select DB you have created. In this case, my DB name is db-ngo, you can see Endpoint & security in the bottom.

2. If you want to connect it by ssh, the format like this:

3. If you want to connect it by Navicat, the format like this: