Determining the MySQL version

This article describes how to determine which MySQL version is installed on a server.

Determining the MySQL version

There are several ways to determine the MySQL version installed on your server. Use whichever of the following methods you prefer.

Method #1: Use cPanel

To determine the MySQL version using cPanel, follow these steps:

1. Log in to cPanel.

   📘

   Note

   If you do not know how to log in to your cPanel account, please see this article.

2. In the right sidebar, under General Information, click Server Information:
   

3. On the Server Information page, locate the MySQL Version row:
   

Method #2: Use phpMyAdmin

To determine the MySQL version using phpMyAdmin, follow these steps:

1. Log in to phpMyAdmin.

   👍

   Tip

   If you are using cPanel, you can log in to cPanel, and then in the Databases section of the cPanel home screen, click the phpMyAdmin icon:
   

2. The phpMyAdmin page appears. In the Database server section appears the MySQL version:
   

Method #3: Use the command line

To determine the MySQL version from the command line, follow these steps:

1. Log in to your account using SSH.

2. At the command prompt, type the following command:

   Bash

   mysql --version

3. To view more detailed MySQL version information, log in to MySQL using the mysql program, and then type the following query:

   Bash

   SHOW VARIABLES LIKE "%version%";

   This shows detailed version information for MySQL, the database engine, the SSL library, and more:

   MariaDB [(none)] SHOW VARIABLES LIKE "%version%";
   +-----------------------------------+------------------------------------------------------------+
   | Variable_name                     | Value                                                      |
   +-----------------------------------+------------------------------------------------------------+
   | in_predicate_conversion_threshold | 1000                                                       |
   | innodb_version                    | 10.3.23                                                    |
   | protocol_version                  | 10                                                         |
   | slave_type_conversions            |                                                            |
   | system_versioning_alter_history   | ERROR                                                      |
   | system_versioning_asof            | DEFAULT                                                    |
   | version                           | 10.3.23-MariaDB-cll-lve                                    |
   | version_comment                   | MariaDB Server                                             |
   | version_compile_machine           | x86_64                                                     |
   | version_compile_os                | Linux                                                      |
   | version_malloc_library            | jemalloc 3.6.0-0-g46c0af68bd248b04df75e4f92d5fb804c3d75340 |
   | version_source_revision           | 607467bd63db2c6ca64610eb9f4e703711f4dfc6                   |
   | version_ssl_library               | OpenSSL 1.0.2k-fips  26 Jan 2017                           |
   | wsrep_patch_version               | wsrep_25.24                                                |
   +-----------------------------------+------------------------------------------------------------+
   14 rows in set (0.002 sec)

• Connecting to MySQL from the command line

• Configuring remote MySQL access

• Checking MySQL database and table sizes

• Working with MySQL database engines

• Importing and exporting a MySQL database

• Determining the PostgreSQL and PostGIS versions