Facebook Twitter Instagram
    TecAdmin
    • Home
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    You are at:Home»Databases»MariaDB»How to Install MariaDB 10.4 on CentOS/RHEL 7/6

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

    By RahulNovember 20, 20193 Mins Read

    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.

    Advertisement

    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.

    database mariadb MySQL SQL
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp

    Related Posts

    A Comprehensive Guide to Optimizing MySQL Table

    Create a Basic CRUD API in NodeJS, ExpressJS and MySQL

    How to Optimize MySQL Parameters for a 32 GB RAM System

    View 5 Comments

    5 Comments

    1. Joseph Mwema on October 24, 2019 5:26 pm

      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
    2. Bas van Beek on October 19, 2019 10:19 pm

      Do not add the yum repository yourself. Instead leave it up by the MariaDB installer:

      curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
      sudo yum install MariaDB-server MariaDB-client

      Reply
    3. Jackon on April 8, 2019 3:28 pm

      Thank you Rahull, worked went perfectly.

      I also installed phpmyadmin, following your other tutorial. https://tecadmin.net/intstall-phpmyadmin-on-centos/

      Thank you for sharing your knowledge with the community.

      Reply
    4. Bob on June 6, 2018 8:05 pm

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

      Reply
    5. Muhaimin on December 20, 2014 6:05 am

      do you have update for centos7

      Reply

    Leave A Reply Cancel Reply

    Advertisement
    Recent Posts
    • Setting and Getting the Default Timezone in Python
    • What is Media Access Control (MAC) Address?
    • What is Cross-Site Scripting (XSS)?
    • What is Content Security Policy (CSP)?
    • A User’s Guide to Understanding Redirection Operators in Bash
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.