Knowledge Base

How to update Centos 7 plesk panel mariadb 10.3

Follow the steps below to update MariaDB 10.3 on your Plesk panel in Centos 7 operating system.

1.First, we connect to our server via SSH and write the following command.

yum install nano wget -y

2. We stop the currently running MariaDB service.

service mariadb stop

rpm -e mariadb-bench

3. We update the MariaDB repository.

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

4. If there is any data on the screen that appears, we delete it. If not, we add the following codes.

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.3/centos7-amd64

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

gpgcheck = 1

5. We exit with the CTRL + X combination and continue by saying "y" for the next warning. Then we stop the MariaDB service.

service mariadb stop

6. We update MariaDB with the new repo.

yum install mariadb -y

7. We restart MariaDB.

service mariadb start

8. We are making other updates as well.

plesk sbin packagemng -sdf

rm /etc/init.d/mysql

systemctl daemon-reload

9. We raise the tables.

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

10. Finally, we restart MariaDB again.

service mariadb restart

All transactions have been completed. If you get a screen like the one below, it means MariaDB has been updated successfully.