How to Check the MySQL Version

Pre-Flight Check
  • 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.
Note: Are you looking to upgrade MySQL on a Liquid Web Core Managed or Fully Managed server? Then contact our Heroic Support® team! And if you’re looking for ways to improve the performance of your VPS, check out our blog on Optimizing Your VPS!

From the Command Line

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

From the MySQL Command Client

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:

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.41-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]>

The server version in this example is Server version: 5.5.41-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.5.40-MariaDB-36.1 |
| protocol_version        | 10                  |
| slave_type_conversions  |                     |
| version                 | 5.5.41-MariaDB      |
| version_comment         | MariaDB Server      |
| version_compile_machine | x86_64              |
| version_compile_os      | Linux               |
+————————-+———————+
7 rows in set (0.10 sec)

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

Try a Free Cloud Server.

Trying a new server is a breeze, and it’ll be up and running in only a few minutes...

Be Sociable, Share!
Here's $75, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support.