Install MariaDB 10.0 on CentOS/RHEL 7/6/5

MariaDB 10.0 stable version has been released on Mar 31, 2014. It is an enhanced, drop-in replacement for MySQL. MariaDB can be a better decision for database experts searching for a robust, scalable, and reliable SQL server. MariaDB has a number of updated features over MySQL.

See Also:

  • How to Install MariaDB 10.0 on ubuntu Server
    mariadb-database
    This article will help you to install MariaDB 10.0 in CentOS, RHEL 7/6/5.

    Step #1 Add MariaDB Yum Repositories

    First add MariaDB yum repository in our system. Create a new repo file in your system and add below code as per your operating system.

    # vim /etc/yum.repos.d/mariadb.repo
    

    For CentOS/RHEL-7 64 Bit

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

    For CentOS/RHEL-6 64 Bit

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

    For CentOS/RHEL-6 32 Bit

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

    For CentOS/RHEL-5 64 Bit

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

    For CentOS/RHEL-5 32 Bit

    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.0/rhel5-x86
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    

    Step #2 Install MariaDB

    After adding mariadb repository, let use following command to install MariaDB 10.0 in your system.

    # yum install MariaDB-server MariaDB-client
    

    Step #3 Start MariaDB Service

    After installing MariaDB in your system, lets start service using following command.

    For CentOS/RHEL 7:
    # systemctl start mysql
    # systemctl enable mysql
    For CentOS/RHEL 6/5:
    # service mysql start
    # chkconfig mysql on
    

    Step #4 Set MariaDB Password

    Finally we need to secure our MariaDB with passwords. To do this run secure installation script from command line.

    # mysql_secure_installation
    

    Step #5 Verify Connection

    After installing and completing configuration, connect to mariadb server using following command

    # mysql -u root -p
    
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 11
    Server version: 10.0.10-MariaDB MariaDB Server
    
    Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    MariaDB [(none)]>
    You may also required install phpMyAdmin to manage MariaDB using web interface, which provides easy way to work.
    

    Enjoy it!

  • No Responses

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

    The reCAPTCHA verification period has expired. Please reload the page.