# In file /etc/my.cnf or /etc/mysql/my.cnf (depending on your operating system), change
# "sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES" or add following
# This should take care of the problem. Another way to change sql_mode directly would be
mysql -u root -p -e „SET GLOBAL sql_mode = ‚NO_ENGINE_SUBSTITUTION‘;“
# But the later option only seems to set the mode temporarely, so I would advise going
# for the my.cnf file.