How to Install MariaDB on CentOS 7 VPS VULTR

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:

1

2

3

yum update-y

yum install mariadb-server

You may also need to finish the installation by running:

1

2

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

1

2

3

4

5

6

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

1

2

3

yum update-y

yum install MariaDB-server MariaDB-client

You can then finish the installation by running:

1

2

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

1

2

3

systemctl start mariadb.service

systemctl enable mariadb.service

You can check to see if everything is running by executing the following command:

1

2

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:

1

2

3

4

5

6

7

8

9

10

11

12

13

Welcome tothe MariaDB monitor.Commands endwith;or\g.

Your MariaDB connection id isXXXX

Server version:5.5.X

Copyright(c)2000,2014,Oracle,Monty Program Ab andothers.

Type'help;'or'\h'forhelp.Type'\c'toclear the current input statement.

MariaDB[(none)]&gt;

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!