Lab Exercise 7b: Setup a RDS MySQL Server in AWS

 

 SETUP A RDS MYSQL SERVER IN AWS:

    To do this experiment, first we should install MySQL Workbench to make the database connection.


Procedure:

1.   Select RDS under AWS Services.





2.   Select 'Create Database'. Then give the options that we want such as Standard Database type, MySQL Engine, Free Tier template, Public Access, etc.,










3.   It may take some time to launch our created database.






4.   Now we go to Security Groups option and add new rules to the Security group that we assigned to the Database with any protocol and from any source.






5. Now open MySQL Workbench and click the plus sign near MySQL Connections to create a new connection to our RDS.




6. Give a name to the connection. Enter the Host name of the DB we created now and use the master password






7.    Now that the database connection is established, we can perform the MySQL queries on our tables. 





Comments

Post a Comment

Popular posts from this blog

Lab Exercise 8: Create and Carryout Read and Write Operation in AWS Dynamo DB​

Image
  Carryout Read and Write Operation in AWS Dynamo DB: Procedure: 1.    Select DynamoDB under AWS Services. 2.    Click 'Create Table' and give table name. Then finally create the table. It will take some time for the table to be available for use.      3.     Select the table and click the 'Explore Table Items' option. 4.    Click 'Create Item' and add attributes and values in the table. Also we can use both form and json format to add. 5.    Let's add some more rows in our table with different attributes. 6.   The Scan Function is to read the data from the Table. We can add filters to get specific row from the table.
Read more