How to Install MariaDB on CentOS 7

Install MariaDB on CentOS 7

In this article, we will have explained the necessary steps to install and configure MariaDB on CentOS 7. Before continuing with this tutorial, make sure you are logged in as a user with sudo privileges. All the commands in this tutorial should be run as a non-root user.

MariaDB is a free and open source fork of well known MySQL database management server software, developed by the brains behind MySQL, it’s envisioned to remain free/open source.

Install MariaDB on CentOS

Step 1. The first command will update the package lists to ensure you get the latest version and dependencies.

sudo yum install epel-release
sudo yum update

Step 2. Install MariaDB 10 on CentOS.

First, create a new file /etc/yum.repos.d/MariaDB.repo to enable MariaDB 10 repository on CentOS using following command:

sudo nano /etc/yum.repos.d/MariaDB.repo

Now add the following lines:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Next, Install MariaDB 10.4 using yum package manager:

sudo yum install MariaDB-server MariaDB-client

After installing MariaDB in your system start it’s service using the following command:

sudo systemctl start mariadb
sudo systemctl enable mariadb

Step 3. Secure the installation of MariaDB.

After installation, we have to improve MariaDB security by typing following:

sudo mysql_secure_installation

Then enter yes/y to the following security questions:

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
    Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
    Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
    Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y

As a test, you can log into the MySQL server and run the version command:

sudo mysqladmin -p -u root version

Congratulation, you have learned how to install and configure MariaDB on CentOS 7. If you have any question, please leave a comment below.