KB Article #176452
Best Practise to use mySQL 5.6 or higher with interchange 5.10.1 to avoid startup Issues
Problem
Errors pop-up in Interchange 5.10.1 during startup when using mySQL 5.6 or higher version.Resolution
These errors could be due to various reasons and the following steps should be taken as best practice when installing Interchange 5.10.1 with mySQL.First, make sure the mySql java connector in the Interchange directory is the latest one. You can download this from the mySQL website. - http://dev.mysql.com/downloads/connector/j/5.1.html
Please make the following changes on the mysql properties file (my.ini). It can be found in 'C:\ProgramData\MySQL\MySQL Server 5.6' on windows.
Then, add the following lines under the [mysqld] section in the file and save it and restart the mysql service.
[mysqld]
transaction-isolation = READ-COMMITTED
default-storage-engine=innodb
innodb_large_prefix
Now, create a new DB schema with default collation as latin1 and use that for Interchange. This should run Interchange with MySql DB without any issues.