Exercise 7(b) : Set up a RDS MySQL server in AWS

-

 To setup a RDS server in AWS:


1. In navigation, select Amazon RDS option. And select create database option.




2.  Select the standard create option in Choose a database creation method .

And in Engine options, select MySQL option.




3. In templates, select Free tier option and fill the unique name in DB instances identifier.







4.  In master username, type the login ID as admin. And in master password enter the password and confirm it again by entering it in confirm master password again.




5. In storage area, select the required storage type and allocate storage as 20 GIB

and leave others as default.


6. In public access, select yes instead of No and note the database port, whether it is 

3306.






7. In database authentication, select password authentication option.

Click  Create button. Copy the endpoint port address.





8. After successful installation of MySQL workbench, select the connection option in the bottom left corner, a window appears and give any connection name(aws-simpli) and in hostname paste the endpoint port that you have copied and give username as admin. And click the store in vault option and enter the password and click test connection. 




9. A windows appears as successfully made the MySQL connection, click ok. If you get failed to connect window , click on your security group that you created and edit your inbound rules.




10. Double click on the mysql connected, and enter the queries and click execute line statement.



11. An output displays as shown below in action output area in the bottom.




















Comments

Post a Comment

Popular posts from this blog

Application-Load balancer

-
Image
Creation of application load balancer for VPC the pre-requisites that are required for this application load balancer are An AWS account https://aws.amazon.com/console/ Now let us look into the steps required for creating a application load balancer: First in order to create a load balancer we need a VPC with different subnets associated with different regions so go ahead and first create a VPC first with following configurations. 2. Now I am going to create four subnets where I use each of two subnets as private and public respectively with different regions for each of them in private and public respectively go to subnets section in your AWS console and click on create subnet enter the configurations as given in the below                                                  Similarly create two other subnets with different regions and Ip addresses. 3. Now we have to...
Read more

My First Virtual Machine

-
Image
      Download the latest version of VirtualBox from the Virtual Box website               according to the version of your operating system Windows  :    After completion of Installation process, the Virtual Box Window gets opened. You can increase the memory size or leave it as the default size Let the storage on physical hard disk be Dynamically allocated   ISO image for OS boot up Click on Storage. Under the Storage section, select the disc (Empty) item.  Under the “Attributes” section,  click the disc icon and select the Choose a disk file button Click on Install Ubuntu  Oracle Guest additions for screen resize and better UI experience  You can resize the screen by the following steps : After authentication ,you need to restart the vm and a larger screen display is available:
Read more