Upgrading MariaDB 10.1 to 10.2 on CentOS 7

0
1788


How to Upgrade

Remove old MariaDB Repository

rm -rf /etc/yum.repos.d/mariadb.repo

Add New MariaDB Repository

vi /etc/yum.repos.d/mariadb.repo

Add

[mariadb]
name = MariaDB Server
baseurl = https://downloads.mariadb.com/MariaDB/mariadb-10.2/yum/rhel/$releasever/$basearch
gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck = 1
enabled = 1

Remove old version

yum remove MariaDB-server -y

Install MariaDB

yum install MariaDB-server MariaDB-shared MariaDB-client MariaDB-common -y

Start MariaDB

systemctl start mysql

Check MariaDB Status

systemctl status mysql

Upgrade Mysql tables

mysql_upgrade

Login to MySQL shell

mysql