how to configure RDS in aws

 How To Configure RDS In AWS

 Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups.

Step 1) Click on Services >> write RDS and enter

Step 2) Click on Database >> click on Create Database

Step 3) Select Standard create >> Select Mysql 

•  You can select database acording your requirement

Step 4) Choose Version >> Select Free Tier

Step 5) Write the DB instance identifier Name >> write master User_name and Password

•  Note : Password should be in Alphabat+Numeric

Step 6) Leave Bydefault DB instance size

• You can modify acording your requirement

Step 7) Leave Bydefault Storage

• You can modify acording your requirement

Step 8) Leave Bydefault Availability & durability

Step 9) Choose Public access YES or NO

• YES - DB Will be Access From Outside

• NO  - Only Amazon EC2 instances and devices inside the VPC can connect to your database. (Not Access From Outside)

Step 10) Choose VPC security group >> Click on Additional configuration

• You can modify port no acording your requirement

Step 11) Leave Bydefault Database authentication

• You can modify Database authentication options acording your requirement

Step 12) Leave Bydefault Additional configuration

• You can modify Database authentication options acording your requirement

Step 13) Click On Create Database

Step 14) Click on DB identifier Name 

Step 15) Copy and paste Endpoint URL >> Click on Security name 

• An Endpoint is the URL of the entry point  or host for the Database.

Step 16) Click on Inbound Rules >> click on Edit Inbound Rules

Step 17) Click on Add Rule >> Choose Mysql >> Select Anywhere 

• Custom   - Only Slected IP Can be Access

• Anywhere - Anyone IP Can be Access

• My IP    - Only Your Ip can be Access

Step 18) Connect Database From Outside (Ubuntu Terminal)

$ mysql -u user_name -p -h Endpoint_url