Skip to content

Instantly share code, notes, and snippets.

@larrybotha

larrybotha/A.markdown

Last active April 27, 2021 09:02
Show Gist options
  • Save larrybotha/288f5e1c5b51fe1bba980f25985b56f8 to your computer and use it in GitHub Desktop.
Save larrybotha/288f5e1c5b51fe1bba980f25985b56f8 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. larrybotha revised this gist Nov 2, 2016. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions A.markdown
    View file
    Original file line number Diff line number Diff line change
    @@ -11,7 +11,7 @@ mysql > SET GLOBAL max_allowed_packet=1073741824;

    courtesy of http://stackoverflow.com/a/18979736/895007

    and add
    and add to `/etc/my.cnf`:

    ```
    # /etc/my.cnf
    @@ -20,7 +20,7 @@ max_allowed_packet=128M

    ## MySQL throwing `ERROR: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created'`?

    Add
    Add to `/etc/my.cnf`:

    ```
    # /etc/my.cnf
  2. larrybotha revised this gist Nov 2, 2016. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions A.markdown
    View file
    Original file line number Diff line number Diff line change
    @@ -14,7 +14,7 @@ courtesy of http://stackoverflow.com/a/18979736/895007
    and add

    ```
    /etc/my.cnf
    # /etc/my.cnf
    max_allowed_packet=128M
    ```

    @@ -23,7 +23,7 @@ max_allowed_packet=128M
    Add

    ```
    /etc/my.cnf
    # /etc/my.cnf
    sql_mode=NO_ENGINE_SUBSTITUTION
    ```

  3. larrybotha revised this gist Nov 2, 2016. 1 changed file with 30 additions and 0 deletions.
    30 changes: 30 additions & 0 deletions A.markdown
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,30 @@
    # 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

    ```
    /etc/my.cnf
    max_allowed_packet=128M
    ```

    ## MySQL throwing `ERROR: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created'`?

    Add

    ```
    /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
  4. larrybotha created this gist Nov 1, 2016.
    5 changes: 5 additions & 0 deletions my.cnf
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,5 @@
    # /etc/my.cnf
    [mysqld]
    max_allowed_packet=128M
    wait_timeout=300
    sql_mode=NO_ENGINE_SUBSTITUTION