EX-7(B) Set up a RDS MySQL server in AWS

                      Set up a RDS MySQL server in AWS


STEP 1 : To set up a RDS MYSQL Server in AWS , navigate to Amazon RDS and click create database.




fill the required details like engine options as "MYSQL" 


Check the mysql  version and in templates choose "freetier"


In settings enter your DB Instance identifier and master username as "admin" , set your master password then confirm your password 




In storage area , select the required storage type and allocate storage as 20 GB and others as default 


In connectivity , change public access no to "yes" and check the database port as "3306"



In database authentication options choose "password connection" and click create create database


    Now we can see the database status as "available"  and choose your database  copy the endpoint address and install the "mysql workbench" 




STEP 2 : Once you copied the endpoint address and open "mysql workbench"
choose setup new connection , fill details like connection name and paste the endpoint address in hostname and give username name as "admin" and click test connection,
 the result will appear as failure . so, navigate to security group rules and edit the inbound rules , click save changes . 





STEP 3 : After editing the security group rule , again open "MYSQL WORKBENCH"  choose setup new connection , fill details like connection name and paste the endpoint address in hostname and give username name as "admin" and click test connection

Once you click test connection a window will appear like this enter your password and click OK 

  


Now you can see successfully made the MYSQL Connection 






STEP 4 : Open your workbench and enter your querry , save it . Once you have saved your querry click run , see the status  in action output. 




Comments