How to check MariaDB server version

Question: I am on a VPS server where MariaDB server is running. How can I find out which version of MariaDB server it is running?

There are circumstances where you need to know the version of your database server, e.g., when upgrading the database or patching any known server vulnerabilities. There are a few ways to find out what the version of your MariaDB server is.

Method One

The first method to identify MariaDB server version is by logging in to the MariaDB server. Right after you log in, your will see a welcome message where MariaDB server version is indicated.

Alternatively, simply type 'status' command at the MariaDB prompt any time while you are logged in. The output will show server version as well as protocol version as follows.

Method Two

If you don't have access to the MariaDB server, you cannot use the first method. In this case, you can infer MariaDB server version by checking which MariaDB package was installed. This works only when the MariaDB server was installed using a distribution's package manager.

You can search for the installed MariaDB server package as follows.

Debian, Ubuntu or Linux Mint:

$ dpkg -l | grep mariadb

The output below indicates that installed MariaDB server is version 10.0.17.

Fedora, CentOS or RHEL:

$ rpm -qa | grep mariadb

The output below indicates that the installed version is 5.5.41.

Download this article as ad-free PDF (made possible by your kind donation): 
Download PDF

Subscribe to Ask Xmodulo

Do you want to receive Linux related questions & answers published at Ask Xmodulo? Enter your email address below, and we will deliver our Linux Q&A straight to your email box, for free. Delivery powered by Google Feedburner.

Support Xmodulo

Did you find this tutorial helpful? Then please be generous and support Xmodulo!

Leave a comment

Your email address will not be published. Required fields are marked *