A Quick Guide for MySQL Installation on Linux using the MySQL Yum Repository

Hello Guys, today I am writing this piece because, one of my close friend is struggling hard to install MySQL on his CentOS system. Although he was well aware of how to install, update or remove any software package using YUM but still he was out of luck. Someone might also face the same problem. This article would help all those who wants to install MySQL on different Linux distribution whether it is EL5-, EL6-, EL7- based platforms (Oracle Linux, Red Hat Enterprise Linux, CentOS) or Fedora 24 & 25. Depending upon requirement, one might want to install MySQL using a third-party-distributed RPM package but that is out of scope from this article.

Note: While writing this piece, I will be installing the MySQL 5.7 on Red Hat Enterprise Linux (CentOS 6.7).
In this article we would discuss below points:
Why MySQL Yum Repository?
How to add the MySQL Yum Repository to our system's repository list?
Which version of MySQL to install?
How to install MySQL using YUM?
How to start the MySQL Server?
Recap! What we did?

How to Remove Comment Box from Static Pages in Blogger

In Blogger, if one enables the commenting functionality then by default comment box would appear below all the posts and static pages. It's recommended and good practice to always hide comment box on static pages like Contact Us, About us etc.

This is "How To" guide for new bloggers showing the steps with screenshots to hide/remove comments box from an existing page or from the new page.

How to Resolve YUM Lock Issue : Another app is currently holding the yum lock; waiting for it to exit...

If you are Linux user or System Administrator then you might face below issue while trying to use YUM command for software package management. It's a very common issue.

The error states that :

Existing lock /var/tmp/yum-vagrant-qt0qu8/x86_64/6/yum.pid: another copy is 
running as pid 5025.
Another app is currently holding the yum lock; waiting for it to exit...
  The other application is: yum
    Memory :  20 M RSS (310 MB VSZ)
    Started: Mon Jun 26 10:49:35 2017 - 00:14 ago
    State  : Traced/Stopped, pid: 5025

This error message tells us two things:

• There is another yum instance running by some processes that are holding the lock.
• The origin of this situation implies that the system does not support YUM concurrent operations.

This is "How To" guide in which we would discuss the solution / workaround of this problem.

YUM Command For Package Management with Examples

It's very common tasks for user or system administrator to install, uninstall, search and update the software packages on Linux systems by using some kind of package manager utility like apt-get, dpkg, rpm, yum, etc.

In this article, we would discuss about one of the software package management utility i.e. YUM. We would discuss different yum commands to search/install/update/remove different software packages.

Points Of Discussion:
What is YUM ?
Different YUM commands
Different Real World Use Cases

Linux Tar Command Tutorial with Examples

This is "How To" guide to show us, how one can create/extract/compress/search archive file using the tar command in Linux. We would discuss below points regarding tar command:

What is the utility of tar command?
What are different types of compression technique used with tar command?
How to install tar package?
5 Tar Command Examples