{"id":1049,"date":"2021-08-16T13:07:55","date_gmt":"2021-08-16T13:07:55","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2021\/08\/16\/5496540-how-to-change-the-mariadb-version-on-cyberpanel-vps\/"},"modified":"2026-05-08T13:02:29","modified_gmt":"2026-05-08T13:02:29","slug":"5496540-how-to-change-the-mariadb-version-on-cyberpanel-vps","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/5496540-how-to-change-the-mariadb-version-on-cyberpanel-vps\/","title":{"rendered":"How to Change the MariaDB Version on CyberPanel VPS"},"content":{"rendered":"

There might be the case when you need to upgrade or downgrade the MariaDB (MySQL) package on your VPS. For example, when currently installed version on your server is not supported by your website’s CMS. <\/p>

\n<\/p>

As an example, in the steps below we will cover a downgrade from MariaDB 10.5 to MariaDB 10.4. You can perform an upgrade or downgrade to any other available version by replacing the version number in the SSH commands. <\/p>

\n<\/p>

Step 1 – Back Up Your Databases<\/h2>

First, connect to your server using SSH<\/b> and check the MySQL password<\/b> using the following command:<\/p>

cat .db_password<\/code><\/pre>
\n<\/p>
This will display the content of the .db_password<\/b> file. Take note of it. Next, create a fresh database backup<\/b>: <\/p>
mysqldump -u root -p --all-databases > databasedump.sql<\/code><\/pre>
When asked to enter the password, use the one you retrieved from the .db_password<\/b> file.<\/p>
\n<\/p>
Step 2 – Remove the Current MariaDB Version<\/h2>
After creating a backup, you can safely<\/b> remove <\/b>the MariaDB version. <\/p>
\n<\/p>
1. Stop <\/b>the MariaDB service:<\/p>
systemctl stop mariadb<\/code><\/pre>
\n<\/p>
2. Uninstall <\/b>MariaDB:<\/p>
yum remove mariadb mariadb-server<\/code><\/pre>
\n<\/p>
3. Remove data and configuration files<\/b> (optional):<\/p>
rm -rf \/etc\/my.cnf
rm -rf \/var\/lib\/mysql<\/code><\/pre>
\n<\/p>
Step 3 – Install the Required MariaDB Version<\/h2>
Now, follow these steps to install the upgraded\/downgraded version:<\/p>
\n<\/p>
1. Open <\/b>the file using a text editor such as vim<\/b> or nano<\/b>:<\/p>
vim \/etc\/yum.repos.d\/MariaDB.repo <\/code><\/pre>
\n<\/p>
2. Update the file<\/b> to the following content:<\/p>
[mariadb]
name = MariaDB
baseurl = http:\/\/yum.mariadb.org\/10.4\/centos7-amd64
gpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB 
gpgcheck=1<\/code><\/pre>
\n<\/p>
3. Update the yum cache index<\/b>:<\/p>
yum makecache fast<\/code><\/pre>
\n<\/p>
4. Install the new version:<\/b><\/p>
yum install MariaDB-server MariaDB-client<\/code><\/pre>
\n<\/p>
5. Enable and start <\/b>MariaDB: <\/p>
systemctl enable mariadb
systemctl start mariadb<\/code><\/pre>
\n<\/p>
6. Secure MariaDB<\/b>: <\/p>
mysql_secure_installation<\/code><\/pre>
Follow the prompts to set a root password and secure the installation. Note that this is the password used to log in to the MariaDB server as a root user<\/b>.<\/p>
\n<\/p>
Use the mysql --version<\/code> command to verify that the version of MariaDB has changed:<\/p>
\n<\/p>
\"VPS<\/div>
Step 4 – Import Your Databases<\/h2>
Finally, import <\/b>your database backup: <\/p>
\n<\/p>
mysql -u root -p root < databasedump.sql<\/code><\/pre>
\n<\/p>
And restart <\/b>MariaDB: <\/p>
systemctl restart mariadb<\/code><\/pre>
\n<\/p>
That’s it, your MariaDB version is successfully updated and your databases restored.<\/p>
\n<\/p>
Additional Resources<\/b><\/p>