Mac OS Sierra MySQL my.conf
# /etc/my.cnf
[mysqld]
max_allowed_packet=128M
wait_timeout=300
sql_mode=NO_ENGINE_SUBSTITUTION
ERROR 2006 (HY000): MySQL server has gone away
?mysql -u root -p
# enter password
mysql > SET GLOBAL max_allowed_packet=1073741824;
courtesy of http://stackoverflow.com/a/18979736/895007
and add to /etc/my.cnf
:
# /etc/my.cnf
max_allowed_packet=128M
ERROR: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created'
?Add to /etc/my.cnf
:
# /etc/my.cnf
sql_mode=NO_ENGINE_SUBSTITUTION