How to check the version of MySQL?

Question

Since LiveAgent version 4.25.16.1 the required version of your InnoDB database engine is 5.6 or higher so before updating your current LiveAgent installation it is a good idea to check what version of InnoDB your server has and whether it meets this requirement. Here are 2 options how you can do it:

Table of Contents Show

From the Command Line
From the MySQL Shell
Conclusion
What is the current version of MySQL?
How to check MySQL in cmd?
How to check MySQL version in MySQL Workbench?
How to check version of MySQL in Ubuntu?

1. Log in to your MySQL server via terminal or via some administrator tool like phpMyAdmin and execute the following SQL query to get the version of the InnoDB engine:

SHOW VARIABLES LIKE "innodb_version"

2. Download the attached mysqlcheck.php script, edit its content to fill in your MySQL credentials (server, user and password) and upload it somewhere onto your server so you can execute it via your browser to see its result.

For example, if you are installing an application that requires a specific MySQL version before starting with the installation you’ll need to find out the version of your MySQL server.

In this article, we’ll show you how to check the version of the MySQL or MariaDB server that is installed on your system.

From the Command Line

If you have SSH access to the server, there are several different commands that can help you determine the version of your MySQL.

The MySQL server binary is named

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

2. To get the server version run the binary using the

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

3 or

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

4 option:

mysqld --version

The command will output information about the MySQL version and exit. In this example the version of the MySQL server is

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

5:

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

6 is a client utility that is used to perform administrative operations on the MySQL servers. It can be also used to query the MySQL version:

mysqladmin -V

The output will be slightly different from the previous command:

mysqladmin  Ver 8.42 Distrib 5.7.27, for Linux on x86_64

From the MySQL Shell

A command client utility such as

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

7, can also be used to determine the version of the MySQL server.

To connect to the MySQL server simply type

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

7:

mysql

Once connected to the MySQL shell, the version will be printed on the screen:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.27-0ubuntu0.18.04.1 (Ubuntu)

To get the information about the MySQL version and other components, query the

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

9 variables:

SHOW VARIABLES LIKE "%version%";

+-------------------------+-------------------------+
| Variable_name           | Value                   |
+-------------------------+-------------------------+
| innodb_version          | 5.7.27                  |
| protocol_version        | 10                      |
| slave_type_conversions  |                         |
| tls_version             | TLSv1,TLSv1.1           |
| version                 | 5.7.27-0ubuntu0.18.04.1 |
| version_comment         | (Ubuntu)                |
| version_compile_machine | x86_64                  |
| version_compile_os      | Linux                   |
+-------------------------+-------------------------+
8 rows in set (0.02 sec)

There are also some other statements and commands that can show you the server version.

mysqladmin -V

0 statement will display only the MySQL version.

SELECT VERSION();

The

mysqladmin -V

1 command shows the MySQL version as well as the information about the server status:

STATUS;

Using PHP

If you are on a shared hosting and you don’t have access to the command line or to a MySQL client like PhpMyAdmin, you can determine the version of the MySQL server using PHP.

In your website document root directory upload the following PHP file using a FTP or SFTP client. Make sure you change the

mysqladmin -V

2 and

mysqladmin -V

3 with an actual MySQL user account :

mysql-version.php

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

0

Open the file in your browser and the version of the MySQL server will be displayed on your screen:

mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))

1

Conclusion

Determining the version of the MySQL server is a relatively easy task. In this guide, we have shown several different options about how to find the MySQL version running on your system.

What is the current version of MySQL?

This version contains the releases of MySQL 5.7 to MySQL 5.6. 27 versions. This version contains the releases of MySQL 8.0 to MySQL 8.0. ... Features Removed in MySQL 8.0..

How to check MySQL in cmd?

Open the mysql command line tool:.

In the Windows Command Prompt, run the command: mysql -u userName -p..

Enter your password when prompted..

How to check MySQL version in MySQL Workbench?

Using MySQL Workbench: Once you are connected to a server using MySQL Workbench, click on Server from main menu and then "Server Status" to view the server status (including version).

How to check version of MySQL in Ubuntu?

We can use a tool like mysqladmin as well. MySQL admin is a command-line utility of the MySQL server administration for checking the MySQL server status. We can use the following command: $ mysqladmin -u root -p status.