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

Network Virtualization

-
Image
 Network virtualization             N etwork Virtualization  is a process of logically grouping physical networks and  making them operate as single or multiple independent networks called Virtual  Networks. Step 1: Create the virtual machine in virtual box Manager. Step 2: In settings, select network and window appears in adapter, enable network adapter  and click Internal network and give the name you want. Step 3: In adapter 2,  it is not attached and click ok button. Step 4: Here you can see window, that in network you can see the changes that you have done. Step 5: Run the virtual machine that you have created , in VMbox.                           Step 6: And in network, select the open network and sharing center which is shown. Step 7: Select the network.  
Read more

Creating VPC Network

-
Image
To create a VPC, subnets, and other VPC resources: 1 . Open the Amazon VPC console at             https://console.aws.amazon.com/vpc/ 2 . In the navigation pane, choose  Your VPCs ,  Create VPC .     Under  Resources to create , choose  VPC. 3.  Modify the options as needed:      ->  Name tag auto-generation,     ->  IPv4 CIDR block : Choose an IPv4 CIDR for the VPC. This option is required.   4.  Choose create VPC: To view VPC details using the console: 1. In the navigation pane, choose VPCs. Select the VPC, and then choose View Details. 2 . After creating VPC , then click security groups option in the navigation bar, then choose create security group option. 3 . A form will open, enter details. Select Id of your VPC , then select the Yes, create button. 4 . The list of groups opens. Select the group name from the list and set rules. Then click the save button. Launch I...
Read more

V2V-VM MIGRATION

-
Image
 VIRTUAL TO VIRTUAL MACHINE MIGRATION  Click the File menu in VirtualBox and select Export Appliance👇 Select the virtual machine you want to export👇 Click Next👇 Click Export👇 VirtualBox will create a nOpen Virtualization Format Archive (OVA file) that VMware can import👇 In the VMware Workstation Import the OVA file in VMware, click the Open a Virtual Machine option and browse to your OVA file👇 VirtualBox and VMware aren’t perfectly compatible, so you would receive a warning message saying the the file “did not pass OVF specification performance” – but if you click Retry, the virtual machine should import and function properly👇 After the import is over, you can find the virtual machine on VMware Workstation Pro👇
Read more