# Fixing Mac OS Sierra MySQL Woes

## MySQL throwing `ERROR 2006 (HY000): MySQL server has gone away`?

```shell
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
```

## MySQL throwing `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
```

courtesy of http://stackoverflow.com/questions/20576917/how-do-i-disable-strict-trans-tables-for-a-homebrew-installed-mysql-server