EXERCISE 7(a) : INSTALLING MYSQL IN AWS

-

To install mySql in AWS: 

1. Assume that you have created an EC2 instance.

2. Select  the ec2 instance you have created and click the connect button.

3. Execute the following command to go to the root.


4. Execute the following command to install mysql server.


5. Execute the following command for secure installation.



6. Hit enter for root password.

    Enter the password. And click y.


7. Enter y to reload privileges tables to shown below.

     Execute the following command to login to the database and enter the password.


8.  Execute the following command to see the databases available.




9. To create database, execute the following command.




10. To create user, execute the following command. And use this command to grant all privileges. To save all the changes, use the following command. And use the quit command to come out of database.





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 create IGW (Internet gateway) and add them as a route in route table of public subnets in order to provide access to any IP
Read more

virtual to virtual migration

-
Image
First download virtual box in your window: Click File -> Export Appliances In that window, click the browse that the file .ova and click next button. And later, select the ubuntu that you have already created.   And click export option. And the window appears like this. In, Vmware workstation, window appears like this. Click open virtual. A window opens, and fill the required that requires.
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