How to update VestaCP to MariaDB 10.3

by Daniel Pham
Published: Updated:

How to update VestaCP to MariaDB 10.3? In this article, I will guide you step by step to do that.

Update VestaCP to MariaDB 10.3

By default, VestaCP will install version MariaDB 5.5.60. A lot of people want to use the latest version of MariaDB.

The current stable version is currently 10.3. And I will guide you to update it.

update vestacp to mariadb 10.3
Update VestaCP to MariaDB 10.3.

First, you need to stop the VestaCP server’s current mariadb service.

service mariadb stop

Next, you need to remove the old MariaDB installation packages.

yum remove mariadb mariadb-server -y

After that, you will need to add MariaDB repository to the VestaCP server. You should choose the correct version according to the OS you are using. For example, I am using CentOS 7 server.

Recommended Reading: How to install MariaDB 10.2 in CentOS 7

Type the following command to create a repo file for MariaDB.

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

Next, copy the content below into the file you just created and save.

# MariaDB 10.3 CentOS repository list - created 2019-04-09 04:55 UTC
name = MariaDB
baseurl =

Then you install MariaDB version 10.3 for new version.

yum install MariaDB-server MariaDB-client -y

After the installation of the packages is complete, restart the mysql service.

service mysql start

And finally, the important step. You run the update command for MariaDB’s current configuration.


The result look like this.

[root@vestacp ~]# mysql_upgrade
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Upgrading from a version before MariaDB-10.1
Phase 2/7: Installing used storage engines
Checking for tables with unknown storage engine
Phase 3/7: Fixing views
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
roundcube.cache                                    OK
roundcube.cache_index                              OK
roundcube.cache_messages                           OK
roundcube.cache_shared                             OK
roundcube.cache_thread                             OK
roundcube.contactgroupmembers                      OK
roundcube.contactgroups                            OK
roundcube.contacts                                 OK
roundcube.dictionary                               OK
roundcube.filestore                                OK
roundcube.identities                               OK
roundcube.searches                                 OK
roundcube.session                                  OK
roundcube.system                                   OK
roundcube.users                                    OK
Phase 7/7: Running 'FLUSH PRIVILEGES'

Now, you can check the update version of MariaDB.

[root@vestacp ~]# mysql -V
mysql  Ver 15.1 Distrib 10.3.14-MariaDB, for Linux (x86_64) using readline 5.1


I’ve guided you step by step to successfully update to MariaDB 10.3. It will make your VestaCP hosting more efficient.

(This is an article from my old blog that has been inactive for a long time, I don’t want to throw it away so I will keep it and hope it helps someone).

0 0 votes
Article Rating

You may also like

Notify of
Inline Feedbacks
View all comments

DevOps Lite is a personal blog specializing in technology with main topics about DevOps, DevSecOps, SRE and System Administrator. Articles are shared for free and contributed to the community.



Subscribe my Newsletter for new blog posts. Stay updated from your inbox!

© 2021-2024 – All rights reserved.

Please write sources “” when using articles from this website.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

Would love your thoughts, please comment.x

Adblock Detected

Please support us by disabling your AdBlocker extension from your browsers for our website.