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.
The first method to identify mySQL or MariaDB server version is by logging in to the mySQL or MariaDB server using the command line client. Right after you log in, your will see a welcome message where SQL 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.
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.
When you run the MySQL command client without any flags the version will be displayed. So while logged in via SSH enter:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.1.29-MariaDB MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
The server version in this example is 10.1.29-MariaDB MariaDB Server.
From within the MySQL client, you can also run the following command for more details:
SHOW VARIABLES LIKE “%version%”;
| Variable_name | Value |
| innodb_version | 5.6.36-82.2 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 10.1.29-MariaDB |
| version_comment | MariaDB Server |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| version_malloc_library | system |
| version_ssl_library | OpenSSL 1.1.0g 2 Nov 2017 |
| wsrep_patch_version | wsrep_25.21 |
10 rows in set (0.02 sec)
In this block of text, you’ll find additional version details about your installed MySQL software like innodb_version, protocol_version, version_ssl_library, and more.
With a command line open, enter the following command:
mysql Ver 15.1 Distrib 10.1.29-MariaDB, for Linux (x86_64) using readline 5.1