1.修改镜像文件

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

Centos7版本

# MariaDB 11.6.1 CentOS repository list

# http://downloads.mariadb.org/mariadb/repositories/

[mariadb]

name = MariaDB

baseurl = https://mirror.mariadb.org/yum/11.6.1/centos7-amd64/

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

# 清除yum缓存

yum clean all

yum makecache

Centos8版本

# MariaDB 10.4 CentOS repository list - created 2021-08-27 01:31 UTC

# http://downloads.mariadb.org/mariadb/repositories/

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.4/centos8-amd64

module_hotfixes=1

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

替换阿里云源

wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo

安装PV

yum install epel-release

yum install PV

2.升级已有数据库

# 安装MariaDB新版本
yum install mariadb mariadb-server
# 启动新版MariaDB
systemctl start mariadb
# 升级已有数据库
mysql_upgrade -uroot -p
# 关联Mysql Mariadb
ln -s /usr/bin/mariadb /usr/bin/mysql