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 Optimize MySQL Parameters for a 32 GB RAM System

    How to Install LAMP Stack on RHEL & CentOS Stream 9

    ERROR 1114 (HY000): The table ‘tablename’ is full (Solutions)

    Add A Comment

    Leave A Reply Cancel Reply

    Advertisement
    Recent Posts
    • Python Function with Parameters, Return and Data Types
    • free Command in Linux (Check Memory Uses)
    • Git Rebase: A Practical Guide
    • How to move the complete Git repository
    • Handling Special Characters in Shell Scripts
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

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