How to check MySQL / InnoDB version of your server

Since LiveAgent version 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.