VPSMATE
  • HOME
  • NEWS
  • VPS
  • DEDICATED
  • ARCHIVES
  • GoDaddy
  • SCRIPT
  • TOOLS
    • Traceroute
    • Benchmark
    • Useful Sites
  • Themes
  • GFW
VPSMATE
VPS COUPON & PROMOS | VPS & DEDICATED SERVERS OFFERS | VPS REVIEWS
  1. Home
  2. Tutorials
  3. This article

How to Upgrade MariaDB to Latest Version on CenOS 7

2020年09月13日 492Browse 0Like 0Comments

Step 1 Remove MariaDB 5.5/10.0/10.1/10.2

Before installing it is recommended to backup your databases, although it is not necessary if you followed this steps carefully.

First backup your current my.cnf config :

cp /etc/my.cnf /etc/my.cnf.bak

Now we need to remove current version of mariadb 5.5 installed on centos 7 :

For MariaDB 5.5 :

service mariadb stop service mysql stop yum remove mariadb mariadb-server

At this point MariaDB 5.5 will be removed completely but the databases are not removed don’t need to worry.

For MariaDB 10.0/10.1/10.2 :

service mysql stop yum remove MariaDB-server MariaDB-client

At this point MariaDB 10.0/10.1/10.2 will be removed completely but the databases are not removed don’t need to worry.

Then Install MariaDB 10.5.5 :

Step 2 Installation/Updating from MariaDB 5.5/10.0/10.1/10.2 to MariaDB 10.3

Install/enable Official repo for mariadb 10.5.5:

yum install nano epel-release -y

Now edit/create the Repo file :

Ensure you don’t have any other MariaDB repo file in /etc/yum.repos.d if exists delete or backup the existing repo file :

mv /etc/yum.repos.d/mariadb.repo /etc/yum.repos.d/mariadb.repo.bak nano /etc/yum.repos.d/mariadb.repo

then paste this lines and save it :

[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.5.5/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1

After that we’ll install Mariadb 10.5.5

yum clean all yum install MariaDB-server MariaDB-client net-snmp perl-DBD-MySQL -y yum update -y

Restore the my.cnf file :

rm -rf /etc/my.cnf cp /etc/my.cnf.bak /etc/my.cnf

Then enable mariadb to start on boot and start the service :

systemctl enable mysql service mysql start

Final Step

After that we need to upgrade current databases by this command :

mysql_upgrade

that’s it you’ve successfully upgraded MariaDB 5.5/10.0/10.1/10.2 to MariaDB 10.3.

You can confirm the version by running this command from terminal ssh:

mysql

Related

Tags: None
Last updated:2020年09月13日

VPSMATE

stay absorbed stay excellent

Like
< Previous

Comments

Cancel reply

Highly Recommended!
Vultr
Links
Suggested Web Hosting
Suggested VPS
1.Unmetered G Port & Unlimited Backups 3.Fast Replies 4.Free credits 5.Torrent Friendly A Name You Can Trust
Digitalocean,$5/Mo-512m KVM+20GSSD

Budgetvm 1G Ram/3IP/80G/$48/yr

Photonvps/512mKVM/10GSSD/5.95$

Linode, Top Xen VPS Company

VPS.net, Top Cloud VPS Company

Domain Discounts
DMCA.com Protection Status

COPYRIGHT © 2020 VPSMATE. ALL RIGHTS RESERVED.

THEME KRATOS MADE BY VTROIS