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:
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 --versionThe 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 -VThe output will be slightly different from the previous command:
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:
mysqlOnce 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 -V0 statement will display only the MySQL version.
The mysqladmin -V1 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 -V2 and mysqladmin -V3 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)) 1Conclusion
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.