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:
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!