Creating RDS + EC2 (Two Tier Architecture)

Objective

To connect RDS with EC2.

• Install MySQL Client on EC2.
• Using mysql command line to connect RDS.
• Create Database name in HC_WYNH

EC2 instance (Ubuntu Server) with app-server-sg (security Group)

RDS instance with db-server-sg (security group)

Installing Mysql client on EC2 (ubuntu).

sudo apt-get install mysql-client

Using mysql command to connect with RDS.

mysql -h {DB End Point} -P LOCAL_PORT -u RDS_USER -p

Creating a Database

:wq!