EX — 7a INSTALLING MYSQL SERVER IN EC-2

  Installation of MySQL server. The pre-requisites required for the following are

  • An AWS account
  • An EC-2 instance with ubuntu iso image file preferably

Here are the steps that I followed to install MySQL server inside EC-2

  1. Connect to your instance through SSH if you are using a Linux machine or through putty if you are using windows

After connecting to the instance use the following commands in order to install MySQL Server

sudo su
cd ../..
sudo apt-get update 
sudo apt-get install mysql-server

After the following commands enter mysql server using the following command

sudo mysql

of course, sudo asks system root password. Once provided the right root password, we will be connected on MySQL as root MySQL user.

use MySQL session to run ALTER USER:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'my-secret-password';

Now its time to run secure installation use the following commands as follows

sudo mysql_secure_installation

After this command press y in all the prompts that follows and also set password when asked

Now again enter into MySQL session using the following commands and perform all the required tasks








Comments

Post a Comment

Popular posts from this blog

EX — 6 Hosting a static website on Amazon S3 ​

Image
 H osting of static website on Amazon s3. The pre-requisites required for the following are An AWS account Static webpage that is previously created by you Navigate to s3 services in AWS console and create a new bucket providing the website name and make sure that you provide public access to the bucket during creation 2. Open the created bucket and enable website hosting under static website hosting options 3. In the fields of index and error document provide landing page file name and 404 page file name 4. Now its time to upload static website files so inside the bucket choose upload option and upload all the files required for hosting 5. Now navigate to permissions tab and enter bucket policy tab and type the following command but do not forget to change the resource field with you bucket ARN { "Version" : "2012-10-17" , "Statement" : [ { "Sid" : "PublicReadGetObject" , "Effect" : "Allow" , "Principal...
Read more

Cloud Computing and it’s future.

Image
  Cloud Computing and it’s future. The first “cloud” image on Google The term ‘cloud’ is quite widespread today in computer science and information technology. There are numerous cloud service providers that are commonly known, which include AWS, Microsoft Azure and the Google Cloud among many others. But what exactly is the cloud and how is computing associated to it? Wikipedia describes it as on-demand computer system resources such as storage or computational power which can be used by any user without its management. This refers to the on-demand delivery of IT and computing resources, applications and data centers via the internet on a pay-for-use basis. This means that computational intensive work can be offloaded onto someone else’s computer which works on your behalf. So, this way we could get work done without owning expensive equipment or trouble ourselves with its maintenance hence reducing capital expenses. The mentioned cloud service providers need to have...
Read more