Skip to content

Instantly share code, notes, and snippets.

@masudcsesust04

masudcsesust04/mysql-error.md

Last active December 3, 2020 17:28
Show Gist options
  • Save masudcsesust04/1084f7ec62bc0e4dc05e1eba34552c3d to your computer and use it in GitHub Desktop.
Save masudcsesust04/1084f7ec62bc0e4dc05e1eba34552c3d to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. masudcsesust04 revised this gist Dec 3, 2020. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions mysql-error.md
    View file
    Original file line number Diff line number Diff line change
    @@ -5,10 +5,10 @@
    sudo nano /etc/mysql/my.cnf
    ```

    2. Scroll to the bottom of file then copy and paste
    2. Scroll to the bottom of file then copy and paste to the bottom of the file
    ```
    [mysqld]
    sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION to the bottom of the file
    sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    ```

    3. `ctrl + x` to to exit input mode
  2. masudcsesust04 created this gist Apr 3, 2018.
    20 changes: 20 additions & 0 deletions mysql-error.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,20 @@
    # Steps to success

    1. Open MySQL configuration file -
    ```
    sudo nano /etc/mysql/my.cnf
    ```

    2. Scroll to the bottom of file then copy and paste
    ```
    [mysqld]
    sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION to the bottom of the file
    ```

    3. `ctrl + x` to to exit input mode

    4. Press `enter` to save and close nano.

    5. `sudo /etc/init.d/mysql restart` to restart MySQL.

    6. Done!