MySQL in AWS RDS
We will learn this tutorial how to configure MySQL in AWS RDS. Then we are connecting database in local machine through HeidiSQL.
Step-1 If already have AWS account just login or create new account.
https://portal.aws.amazon.com/billing/signup#/start/email
Step-2 Search in search box RDS. Then select RDS.
Step-3 Then click create database.
Step-4 when you have clicked create button there will be open database create. Here show two option first one is standard create and second one is easy create. you select standard create option.
After that select engine option. there are many option. where you have to select MySQL option.
Just leave engine type default. then choose template free tier. when you select free tier there are disable availability multi-AZ. you can leave default DB instance identifier or give new name.
You can leave all option default. Because we don’t want to deep dive into all option. But when you want to connect database in your local machine you should to select public access yes option.
If you want to create replica of this instance then you have to enable automated backups because without automated backup you can not create replica. When you click create button they take some time. After creation of instance click DB identifier and note your Endpoint & Port. because this end point is required in database connection.
Finally you have done RDS instance creation. then you have to required to create database and table. you can download HeidiSQL in this link
After download you need to install HeidiSQL. Then open HeidiSQL and enter you credentials. Here required end point of you install.
Network type select MySQL on RDS
Hostname/IP address is you endpoint and enter user name and password. then click open button.
Thank you for reading this tutorial.
