Check mySQL and MariaDB Server Version

To totally unlock this section you need to Log-in.

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 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.

Check mySQL and MariaDB Server Version

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.

Check mySQL and MariaDB Server Version

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.

Check mySQL and MariaDB Server Version

Fedora, CentOS or RHEL:

$ rpm -qa | grep mariadb

The output below indicates that the installed version is 5.5.41.

Check mySQL and MariaDB Server Version

Method Three

When you run the MySQL command client without any flags the version will be displayed. So while logged in via SSH enter:

mysql

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.

Method Four

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.

Method Five

With a command line open, enter the following command:

mysql -V

mysql Ver 15.1 Distrib 10.1.29-MariaDB, for Linux (x86_64) using readline 5.1