Creating RDS mysql database SERVER and connecting via EC2 and via workbench

Creating RDS mysql database SERVER and connecting via EC2 and via
workbench

Create a VPC
Create IGW
Attach IGW
Create subnets
Create Route Table
Create RDS data base chose mysql with the security port 3306 and add port ssh 22.
Create EC2 Instance with the same security group which is used for RDS. With the same ports 3306 and ssh 22.
*(Important thing to remember Availability zone must be the same for database and for EC2 instance)
Now connect to your created EC2 Instance via Putty.
Ec2-user
Sudo su –
Now Install mysql via command
yum Install mysql -y
Now Connect to your database via below cmd.
Mysql -h type or paste here your database endpoint root -u (your user name) -p (databse name in advance settings) db1

2ndway
Create database and connect it through workbench

[JustAbdouIt]

Thank you so much!! You made it all so much simpler for me

[abcrectify]

Can you make a video only host mysql in ec2 and connect to workbench. without creating RDS. share your contact details please.