Posts

MySQL Secure Installation

Image
mysql_secure_installation is basically used to improve the security of the mysql server installation. Key benefits: Prevent unauthorised access to the database server by setting strong password for the root user. It also helps in removing anonymous users and disallowing remote root login .  Now we will look at the steps to safely secure your mysql server: Step 1: First check the path where mysql_secure_installation is present                       which mysql_secure_installation                                                                  You can also check out the file permission by :                       ls -ltr /usr/bin/mysql_secure_installation  ...
Post a Comment
Read more

Installing Percona Server for MySQL server and Removing MySQL

Image
Here, we will first install Percona Server for MySQL server and then see how to remove MySQL server We will begin with a new VM (to check how to install VM you can check on my previous post) Before starting your terminal should look like this: If not then you check the previous post, for creating and running a VM Now let's begin with the installation steps Step 1: Download Percona MySQL repo package                     wget https://repo.percona.com/yum/percona-release-latest.noarch.rpm Step 2: Installing Percona MySQL repo locally                     sudo yum localinstall percona-release-latest.noarch.rpm Step 3: Enable Repo for Percona MySQL 8                     sudo percona-release setup -y ps80 Step 4: Install MySQL Percona Server                    su...
Post a Comment
Read more

Creating VM in AWS and installing MySQL Server Community Edition

Image
Here we will first look on how to create a VM with the help of AWS(Amazon Web Services) and then we will continue with the installation of the MySQL Server Community Edition I will provide you with the step by step explanation and the process. Step 1: Create your AWS account or log in to your AWS account Step 2: Then click/search on EC2 instances in the console Step 3: Click on Launch Instances, and fill up the following details:                              3.1 Names and tags:                                 Instance name: db01 (you can keep any name)               3.2   Application and OS Images (Amazon Machine Image):                               AMI: Amazon Linu...
Post a Comment
Read more