Directadmin – How to Disable Strict mode in Mysql

Wyłączenie STRICT_TRANS_TABLES w directadmin:

dodaj do /etc/my.cnf:

[mysqld]
max_allowed_packet=64M
local-infile=0
innodb_file_per_table
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

[client]
socket=/var/lib/mysql/mysql.sock