MySQL

Create a new database with UTF8 encoding for Squash TM, and grant all rights on this database for a user:

CREATE DATABASE IF NOT EXISTS squashtm CHARACTER SET utf8 COLLATE utf8_bin;

CREATE USER 'squash-tm'@'localhost' IDENTIFIED BY 'initial_pw';

GRANT ALL ON squashtm.* TO 'squash-tm'@'localhost';

FLUSH PRIVILEGES;

Warning

SquashTM must be installed in InnoDB tables.

Installing SquashTM with another database engine will corrupt your data.

Prior to MySQL 5.5.5 the default MySQL engine was MyISAM. Please DO NOT install Squash TM on MyISAM tables and :

double check that your default engine is InnoDB.

See your MySQL version documentation for further information on database storage engine

MySQL Configuration

For MySQL versions 5.7 and over, of for MariaDB, the @@sql_mode variable must contain the tags:

NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

This varaible has to be set in the configuration file my.ini, in the section [mysqld].