How to Install MySQL on CentOS 7: A Step-by-Step Guide

MySQL is a popular open-source relational database management system that is widely used for web applications. In this article, we will provide a step-by-step guide on how to install MySQL on CentOS 7.

Introduction to MySQL

MySQL is a popular open-source relational database management system that is used to manage and store data in a relational format. It is commonly used for web applications, and it is compatible with many different operating systems.

Prerequisites

Before we begin with the installation, ensure that you have the following:

A CentOS 7 server with root access.

A non-root user with sudo privileges.

A stable internet connection.

Step 1: Update the System

The first step is to update the system to ensure that you have the latest packages and security updates. Use the following command to update the system:

sudo yum update -y

Step 2: Install the MySQL Repository

Next, you need to install the MySQL repository to get the latest version of MySQL. Use the following command to download and install the MySQL repository:

sudo yum install https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

Step 3: Install MySQL Server

After installing the repository, you can proceed to install the MySQL server. Use the following command to install MySQL:

sudo yum install mysql-server

Step 4: Start and Enable MySQL

Once the installation is complete, start the MySQL service and enable it to start automatically on boot using the following commands:

sudo systemctl start mysqld sudo systemctl enable mysqld

Step 5: Secure MySQL Installation

By default, MySQL installation is not secure, and anyone can log in to the MySQL server without a password. To secure the installation, run the following command:

sudo mysql_secure_installation

You will be prompted to set a root password, remove anonymous users, disallow remote root login, and remove test databases.

Step 6: Verify MySQL Installation

To verify that MySQL is installed correctly, use the following command to check the MySQL service status:

sudo systemctl status mysqld

If the service is running, you can also check the MySQL version using the following command:

mysql --version

Conclusion

In conclusion, MySQL is a popular open-source relational database management system that is widely used for web applications. Installing MySQL on CentOS 7 is a straightforward process that involves updating the system, installing the MySQL repository, installing the MySQL server, starting and enabling the MySQL service, securing the installation, and verifying the installation.

FAQs

Q: How do I uninstall MySQL on CentOS 7?

To uninstall MySQL on CentOS 7, use the following command: sudo yum remove mysql-server.

Q: How do I start and stop MySQL on CentOS 7?

To start MySQL on CentOS 7, use the following command: sudo systemctl start mysqld. To stop MySQL, use the following command: sudo systemctl stop mysqld.