• These instructions are intended for checking the MySQL version on your server.
• I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.

The following command:

mysql -V

Should return something similar to:

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

When you connect to MySQL using a command client with the following command, the version of the MySQL server is displayed:

mysql

You should receive a result similar to:

The server version in this example is Server version: 10.1.20-MariaDB MariaDB Server.

Once connected to the MySQL Command client, you can also run the command:

SHOW VARIABLES LIKE "%version%";

Which should return a result similar to:

+-------------------------+---------------------------------+
| Variable_name           | Value                           |
+-------------------------+---------------------------------+
| innodb_version          | 5.6.34-79.1                     |
| protocol_version        | 10                              |
| slave_type_conversions  |                                 |
| version                 | 10.1.20-MariaDB                 |
| version_comment         | MariaDB Server                  |
| version_compile_machine | x86_64                          |
| version_compile_os      | Linux                           |
| version_malloc_library  | system jemalloc                 |
| version_ssl_library     | OpenSSL 1.0.1e-fips 11 Feb 2013 |
| wsrep_patch_version     | wsrep_25.16                     |
+-------------------------+---------------------------------+
10 rows in set (0.00 sec)

Looking for other MySQL tutorials? We have two awesome series! First, Basic Database Interaction. Second, Basic User Interaction. Check them out below!