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 8 & RHEL 8

    How to Install MariaDB 10.4 on CentOS 8 & RHEL 8

    By RahulNovember 20, 20192 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 8 and RHEL 8 systems.

    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.

    sudo vi /etc/yum.repos.d/mariadb.repo
    
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.4/rhel8-amd64
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    

    Step 2 – Install MariaDB on CentOS 8

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

    sudo dnf makecache
    sudo dnf install MariaDB-server MariaDB-client --disablerepo=AppStream
    

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

    sudo systemctl start mysql.service
    

    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 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.

    CentOS 8 mariadb RHEL 8
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp

    Related Posts

    How to Install MariaDB on Ubuntu 22.04

    How to Install MariaDB on Ubuntu 22.04

    How to Install Mariadb (MySQL) on Debian 11

    How To Install MariaDB on Debian 11

    Installing Security Updates on CentOS 8

    How To Install Security Updates on CentOS 8 (Manual + Automatic)

    Add A Comment

    Leave A Reply Cancel Reply

    Advertisement
    Recent Posts
    • How to Install PHP 8.2-7.4 on RHEL & CentOS Stream 9
    • How to Install MySQL 8.0 on RHEL & CentOS Stream 9
    • How to Split Large Archives in Linux using the Command Line
    • System.out.println() Method in Java: A Beginner’s Guide
    • Split Command in Linux With Examples (Split Large Files)
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

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