Install MariaDB on CentOS 7
Forked from MySQL, MariaDB has been known to be a drop-in replacement that brings enhancements and performance optimizations over MySQL. This tutorial will show you how to install MariaDB onto CentOS 7 in two different ways.
Step 1: Download/install MariaDB
Install from repository
MariaDB is shipped in the CentOS repo as of CentOS 7. Anything lower will need require you to add the additional repository to your server. Run the following command on your server:
yum update -y
yum install mariadb-server
You may also need to finish the installation by running:
/usr/bin/mysql_secure_installation
This will install MariaDB and walk you through the process of setting up your root password.
Manual install from MariaDB mirror (latest version)
This should be straightforward. You will need to create a file in /etc/yum.repos.d/
and add the following:
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
Once the file is created, run the following commands:
yum update -y
yum install MariaDB-server MariaDB-client
You can then finish the installation by running:
/usr/bin/mysql_secure_installation
If everything was successful, proceed to the next step.
Step 2: Verify that MariaDB is operational
Depending on if you are using the default Vultr image of CentOS 7 or if you are using a Custom ISO, you may need to manually start MariaDB and enable it to start on boot of the server. To do so, run:
systemctl start mariadb.service
systemctl enable mariadb.service
You can check to see if everything is running by executing the following command:
systemctl is-active mariadb.service
After installation, run mysql -u root -p
. Enter your password when prompted. You will see output similar to the following:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is XXXX
Server version: 5.5.X
Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
Congratulations, you have successfully installed MariaDB on CentOS 7. If you get an error regarding connection, please make sure that MariaDB is running by repeating the beginning of Step 2. Enjoy!