How to create Relational Database Service (RDS) in AWS.

How to create Relational Database Service (RDS) in AWS.

Step 1- Login to the AWS console.

Step 2 - Go to services. Click on Database and choose RDS.

Step 3 - On the Amazon RDS dashboard, click on the "Create database" button.

Step 4 - Choose the Database creation method you want to create.

Step 5 - Choose the database engine you want to use for your RDS instance. (Amazon RDS supports various engines such as Amazon Aurora, MySQL, PostgreSQL, Oracle, etc. Select the appropriate option based on your requirements.)

Step 6 - Fill in the necessary information for your RDS instance. (License Model, DB engine version, Template, DB instance identifier and Master username and password.).

Step 7 - Now choose to connect to an Ec2 Compute resource.

Step 8 - If you have already created Ec2 then choose Ec2 Otherwise create an Ec2 instance.

Step 9 - Choose the default VPC.

Step 10 - Configure Additional Configuration.

Step 11 - Click to Create Database.

Step 12 - To excess the RDS go to the Ec2 instance and connect to the network.

Step 13 - Switch the user to sudo su.

Step 14 - install MySQL.

cmd - yum install mysql .

Step 15 - Copy the endpoint of RDS.

Step 16 - To Excess write command -

mysql -h <Endpoint of your RDS> -u admin -p <name of your database>

Step 17 - Write the same password while you create creating RDS.

Step 18 - you are in MySQL. :)