How To Check MariaDB Version [Several Ways]

In this MariaDB Tutorial, we are going to learn How to check the MariaDB version on the different operating systems. Additionally, we will cover the following topics.

How To Check MariaDB Version In Linux
How To Check MariaDB Version In Windows
How To Check MariaDB Version In Ubuntu
How To Check MariaDB Version In Heidisql

Table of Contents

How To Check MariaDB Version In Linux

Let us see, how to check the MariaDB version in Linux.

The MariaDB software is managed by the MariaDB Foundation whose headquarters is in Finland and the United States Of America. There are several methods to check the MariaDB version in Linux.

Using The –version Option
Check version using Mysql shell
Using The STATUS Command

Using The –version Option

In Linux, if we don’t have MariaDB open on our PCs, we can find out the MariaDB version by using the –version option of the mariadb, mariadb-admin, mysqladmin programs.

We can open a new terminal window in Linux and run the following command.

mariadb --version

mysqladmin -V

Check The Version Using MySQL Shell

We can switch to the MYSQL shell to create a database, at the same we can get the details of the version. And we can do this by using the following command.

sudo mysql

Using The STATUS Command

We can anytime type STATUS whenever you’re logged into the server of MariaDB in Linux OS to check information about the version of MariaDB and other details.

Let us see, how can we check the version MariaDB through the STATUS Command in Linux.

STATUS;

Read How to install MariaDB

How To Check MariaDB Version In Windows

Let us see, how to check the MariaDB version in Windows.

The MariaDB software is managed by the MariaDB Foundation whose headquarters is in Finland and the United States Of America. There are several methods to check the MariaDB version in Windows.

Using @@version Keyword in MariaDB
Using the VERSION( ) Function
Using VARIABLES Keyword With SHOW in MariaDB
Using the STATUS Command
While Logging In the MariaDB Server
Using the –version Option

Using @@version Keyword in MariaDB

Using the @@version keyword in MariaDB, we can get the version of MariaDB installed in our system. We can simply retrieve its content by using the SELECT statement.

Below is the syntax to check the version of MariaDB:

SELECT @@version
FROM DUAL;

In the below output, we can see that the version of MariaDB installed is 10.6.5.

Check MariaDB Version Using @@version — Checking MariaDB Version Using @@version

Using the VERSION( ) Function

Using the VERSION( ) method, we can find the version of MariaDB installed in our operating system. The output will be similar to the previous section.

Its content can also be retrieved through the SELECT statement.

Let us see, how can we check the MariaDB version through this function.

SELECT VERSION()
FROM DUAL;

This is what the output should look like.

Using VARIABLES Keyword With SHOW in MariaDB

The VARIABLES keyword contains information like version, version_compile_os, version_compile_machine, etc. The information is maintained in a tabular format with two columns as Variable Name, and Value.

SHOW in MariaDB displays the information about databases, tables, variables, etc. SHOW VARIABLES displays the MariaDB system variables. We can use the WHERE clause to limit the variables just to the version variable.

Let us see, how can we check the version MariaDB through the VARIABLE keyword with SHOW in MariaDB.

-- view version and other info
SHOW VARIABLES

-- view version only
SHOW VARIABLES
WHERE variable_name = 'version';

-- detailed view of version
SHOW VARIABLES
WHERE variable_name LIKE '%version%';

The below output shows the version of MariaDB installed in our operating system. The version is displayed in a tabular format with variable name as version and value as 10.6.5-MariaDB

How To Check MariaDB Version — MariaDB Version Using SHOW VARIABLES Statement

The below output shows the detailed information with a version of MariaDB in our operating system.

Check MariaDB Version Using SHOW VARIABLES With LIKE — MariaDB Version Using SHOW VARIABLES Statement With LIKE Operator

Using STATUS Keyword in MariaDB

Use the STATUS keyword in MariaDB to display information about the MariaDB server. The status will display information like connection id, current user, SSL if used, MariaDB server version, etc.

Let us see, how can we check the version MariaDB using the STATUS keyword in MariaDB.

STATUS;

This is what the output should look like.

Check MariaDB Version — MariaDB Version Using STATUS Command

While Logging into the server of MariaDB

Whenever we log into the server of MariaDB using the root password, there is a Welcome message under which the version number is presented.

The following ‘Welcome’ message is shown.

This is what the Welcome Message should look like.

Using –version to view the MariaDB version

If we don’t have MariaDB open on our PCs, we can find out the MariaDB version by using the –version option of the mariadb, mariadb-admin, mysqladmin programs.

We can open a terminal window and run the below command.

mariadb --version

Read How to Create Database in MariaDB

How To Check MariaDB Version In Ubuntu

Let us see, how to check the MariaDB version in Linux.

The MariaDB software is managed by the MariaDB Foundation whose headquarters is in Finland and the United States Of America. There are several methods to check the MariaDB version in Ubuntu.

Using The STATUS Command
While Logging In to the MariaDB Server
By Checking MariaDB Package

Using The STATUS Command

We can anytime type STATUS whenever you’re logged into the server of MariaDB in Linux OS to check information about the version of MariaDB and other details.

Let us see, how can we check the version MariaDB through the STATUS Command in Linux.

STATUS;

While Logging In to the MariaDB Server

Whenever we log into the server of MariaDB using the root password, there is a Welcome message under which the version number is presented.

The following ‘Welcome’ message is shown.

By Checking MariaDB Package

If you don’t have access to the server of MariaDB, We can infer the version of the MariaDB server by checking which package of MariaDB was installed. It works only after the MariaDB server was installed using the distribution package manager.

Here, we can search for the installed MariaDB server package by typing the following command.

dpkg -l | grep mariadb

How To Check MariaDB Version In Heidisql

In this section, we will discuss how to check the MariaDB version in Heidisql. HeidiSQL is a freely available SQL client for Windows and it comes preinstalled with MariaDB. It is a tool that helps in creating various database objects like tables, stored procedures, and many more.

Moreover, we can utilize the Heidisql tool for executing a variety of SQL statements on the MariaDB instance including the statement to check the version of MariaDB. Though Heidisql comes preinstalled with MariaDB. Still due to the issue, if Heidisql is not installed, we can download and install it from the following download page.

Once the Heidisql tool is installed, we first need to run it and connect it to our MariaDB instance. In the last, we can use the following query in Heidisql to check the version of MariaDB.

SELECT VERSION() AS "MariaDB Version";

After executing the above SQL statement, we will get the version of the currently connected MariaDB server.