How to Install MariaDB 10.4 on CentOS/RHEL 7/6

    RahulBy 3 Mins ReadUpdated:

    MariaDB 10.4 stable version has been released. It is an enhanced, drop-in replacement for MySQL. MariaDB can be an better choice for choice for database professionals looking for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL. Use below links to read features comparison between MariaDB and MySQL. This article will help you to install MariaDB 10.4 in CentOS, RHEL 7/6 and Fedora Fedora 30/29/28 systems using yum.

    Step 1 – Add MariaDB Yum Repository

    First add MariaDB yum repository in our system. Create a new repo file /etc/yum.repos.d/mariadb.repo in your system and add below code as per your operating system and architecture.

    For CentOS/RHEL – 7 

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

    For CentOS/RHEL – 6 

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

    For Fedora – 30/29/28

    Please change the version (red highlighted) in the below setting as per the version of Fedora you used. Click here to view all available repositories.

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

    Step 2 – Install MariaDB Server

    Let’s use the following command to install MariaDB 10.4 in your system. This will also install other dependencies automatically.

    #### For CentOS/RHEL 7/6
sudo yum install MariaDB-server MariaDB-client

#### For Fedora
sudo  dnf install MariaDB-server MariaDB-client

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

    ## CentOS/RHEL 7 
sudo systemctl start mysql.service

## CentOS/Redhat 6 
sudo service mysql start

    Step 3 – Secure MariaDB Install

    You also need to secure your MariaDB installation using passwords and do some other changes. To do this run secure installation script from the command line.

    sudo /usr/bin/mysql_secure_installation

    The secure installation script will ask for user input as some points, follow the installation as per below output showing, All user inputs are highlighted with red color.

    NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!

Remove anonymous users? [Y/n] y
 ... Success!

Disallow root login remotely? [Y/n] y
 ... Success!

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...
Thanks for using MariaDB!

    Step 4 – Working with MariaDB

    After installing and completing the configuration, connect to a MariaDB server using the following command.

    sudo mysql -u root -p

    Also try to create a new database, user and assign privileges to a database.

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    ## CREATE DATABASE
    MariaDB [(none)]> CREATE DATABASE mydb;
    ## CREATE USER ACCOUNT
    MariaDB [(none)]> CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'secret';
    ## GRANT PERMISSIONS ON DATABASE
    MariaDB [(none)]> GRANT ALL ON mydb.* TO 'dbuser'@'localhost';
    ##  RELOAD PRIVILEGES
    MariaDB [(none)]> FLUSH PRIVILEGES;

    You may also required install phpMyAdmin to manage MariaDB using web interface, which provides easy way to work.

    Share.

    Related Posts

    5 Comments

    1. Joseph Mwema on

      Please update

      ## CentOS/RHEL 7
      sudo systemctl start mysql.service

      ## CentOS/Redhat 6
      sudo service mysql start

      to

      systemctl start mariadb

      or

      service mariadb start

      This will come in handy for anyone who has installed MariaDB 10.4.8

      Reply
    4. Bob on

      I followed these directions. YUM is insisting on trying to install mariaDB 10.1 even though I specified 10.3 like you said…

      Reply

    Leave A Reply