How to Check the MySQL Version

Reading Time: 2 minutes

In this quick tutorial, we’ll learn how to check the MySQL version of a server. Without a doubt, MySQL is one of the most popular RDBMS (Relational database management system)  options available, so you’ll find it pretty much everywhere. There can be some pretty staggering differences between MySQL versions, so knowing which version you’re working with is important. Learn here how to check the version of MySQL your server is using!

Let’s start with a quick video review of this subject;
 

Check the MySQL version

Pre-Flight Check
  • These instructions are intended for checking the MySQL (or MariaDB) version on your server.
  • We’ll be working from our high-availability MySQL server, and I’ll be logged in as root.

From the Command Line

  1. With a command line open, enter the following command:
    subject
    mysql -V
    mysql Ver 15.1 Distrib 10.1.29-MariaDB, for Linux (x86_64) using readline 5.1

 

Note:
Are you looking to upgrade MySQL on a Liquid Web Core Managed or Fully Managed server? Then contact our support team! If you’re looking for ways to improve the performance of your VPS, check out our blog on Optimizing Your VPS!
 
Here's 75% off a New VPS! Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support
 

From the MySQL Client

  1. When you run the MySQL command client without any flags the version will be displayed. So while logged in via SSH enter:
    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.

  2.  

  3. 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_versionprotocol_versionversion_ssl_library, and more.

 

From The PHPMyAdmin Interface

If you aren’t familiar with running commands through ssh, you may have access to PHPMyAdmin on the server which gives a nice graphical interface for managing the databases. If you have cPanel or Plesk access you should be able to open PHPMyAdmin when logged in to the hosting account. In PHPMyAdmin on the right side, it should have information listen under the “Database server” section and the “Server version” is what shows the MySQL or MariaDB version is running on the server.

phpmyadmin-screenshop



When standard uptime is not enough, you don’t have to wage war alone. Liquid Web’s High-Availability Databases provides the bleeding edge hardware needed for keeping your site online. Does significantly reducing overhead while not having to worry about managing MySQL sounds like a dream come true?  Then check out our affordable plans!

Author Bio

About the Author: Alex Gorzen

Alex Gorzen has been helping others with technology his whole life. He played with computers even before he could read and wants to make sure his children share that same love as they grow up. In his free time he enjoys gardening, building things, and learning new skills.

Get 33% off the first 3 months on a new VPS! Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7x365 Support