AWS RDS MySQL Database Creation

AWS RDS (Amazon Relational Database Service) is known for its simple setup, easy to operate and scale database in the cloud.The clients won’t have to worry about the backups, loss of data or the installation, the AWS will do that for the client. It is highly secure and 0 to no downtime for the users.


To create the RDS we will need to an Amazon Web services Account for this purpose we will work on Free Tier Account: How to create Free tier Account 


  • In the search bar type RDS and RDS service should show up.



  • Click on Create Database.




  • Select Standard Create, under Choose a database creation method



Note: This demo is for MySQL RDS, so we will be working on the MySQL.


  • Select MySQL, under Engine options and leave default for other option under it.



  • Under Templates, choose Free tier Option



  • Enter desired database name, under Settings “DBTEST01” (For Demo) and create password for your database as we will be accessing it using password.



  • Leave everything else as Default, and scroll down to Public Access under Connectivity. We will be connecting it with our EC2 instance using our terminal through ssh



  • Click on the Create database button. It will take some time to create our EC2 Instance If it doesn’t already exist. How to create EC2 Instance



To connect to our Database using Mac Terminal and EC2 Instance


Comments