HostSEO Blog

Stories and News from IT Industry, Reviews & Tips | Technology Blog

Upgrade Mysql 5.7 to MariaDB 10.2 on CentOS7

In this article, I’m going to upgrade Mysql5.7 to Mariadb 10.2 on CentOs7 system. This is a simple procedure that yoyu can easly follow.

Login as root user in to your system through SSH.

You can get the current mysql version by running following command.

#  mysql -V

Now follow the below steps one by one to upgrade to Mariadb10.2

1. Stop mysql service

#  systemctl stop mysql

2. Take the backup of databases.

Be sure to backup MySQL before upgradation process with the following instructions!

# cp -apf /var/lib/mysql /var/lib/mysql_backup
#  mysqldump --all-databases > all_databases.sql

3. Remove the existing mysql package from the system.

#  yum -y remove mysql-server mysql-client

4. Add MariaDB repository.

# vi  /etc/yum.repos.d/MariaDB.repo 

And copy the following line to the repsitory file.

name = MariaDB
baseurl =

:wq!  (save and exit)

Install MariaDB10.

Installation of MariaDB can be done by following simple step.

# yum -y install MariaDB-server MariaDB-client 

Start MariaDB service.

# systemctl start mariadb.service
# systemctl enable mariadb.service

Run mysql upgrade command

 # mysql_upgrade

You have succesfully upgraded to mariadb10 and you can verify it by running following command

# mysql -V

You will get following as output.

mysql Ver 15.1 Distrib 10.2.23-MariaDB, for Linux (x86_64) using readline 5.1

Subscribe Now

10,000 successful online businessmen like to have our content directly delivered to their inbox. Subscribe to our newsletter!

Archive Calendar


Born in 2004 ... Trusted By Clients n' Experts

SEO Stars

They never made me feel silly for asking questions. Help me understand how to attract more people and improve my search engine ranking.

Read More

Emily Schneller Manager at Sabre Inc
SEO Stars

Took advantage of Hostseo's superb tech support and I must say, it is a very perfect one. It is very fast, servers reliability is incredible.

Read More

Leena Mäkinen Creative producer
SEO Stars

We're operating a worldwide network of servers with high quality standards requirements, we’ve choose hostseo to be our perfect partner.

Read More

Ziff Davis CEO at Mashable
SEO Stars

It’s very comfortable to know I can rely about all technical issues on Hostseo and mostly that my website and emails are safe and secured here.

Read More

Isaac H. Entrepreneur
SEO Stars

With hostseo as a hosting partner we are more flexible and save money due to the better packages with great pricing, free SEO n' free SSL too!

Read More

Madeline E. Internet Professional