How to Upgrade MariaDB 5.5 to MariaDB 10.0 on CentOS 7

Step #1: Add the MariaDB Repository

First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new:

yum -y update


Now find which repo you should use with the MariaDB repository generator. We’re going to add the CentOS 7 (64 bit) MariaDB 10.0 repository.

vim /etc/yum.repos.d/MariaDB10.repo

# MariaDB 10.0 CentOS repository list – created 2014-10-13 13:04 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Then exit and save the file with the command :wq .


Step #2: Remove the Existing MariaDB Installation


Be sure to backup MariaDB before proceeding with the following instructions!


Stop MariaDB:

systemctl stop mariadb


Remove the existing MariaDB packages:

yum -y remove mariadb-server mariadb mariadb-libs


Clean-up the repository cache information with the following command:

yum clean all


Step #3: Install MariaDB 10.0


At this point, installing MariaDB 10.0 is as simple as running just one command:

yum -y install MariaDB-server MariaDB-client


And then start MariaDB again:

systemctl start mysql


Be sure that MariaDB is set to start at boot:

systemctl enable mysql


Run mysql_upgrade:

mysql_upgrade


Verify MySQL is now MariaDB by using the command client:

mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.0.14-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)]>

  • 38 Users Found This Useful
Was this answer helpful?

Related Articles

Update and Patch OpenSSL for Heartbleed Vulnerability

What is OpenSSL? OpenSSL is a common cryptographic library which provides encryption,...

How to Disable Automatic Background Updates for WordPress Core

The following process works with all WordPress versions after version 3.7. There are several...

How to Install VNC Server on Ubuntu 14.04 LTS

VNC is short for ‘Virtual Network Computing’. It’s a simple method for sharing a graphical...

Fighting Spam on cPanel Servers

On cPanel servers there are a several different tools that are built into cPanel that can be used...

How to Install WordPress in cPanel / WHM with Softaculous

WordPress is a very popular option for running a website or blog and can be used to get your...

Powered by WHMCompleteSolution