- Open MySQL configuration file -
sudo nano /etc/mysql/my.cnf
- 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
-
ctrl + x
to to exit input mode -
Press
enter
to save and close nano. -
sudo /etc/init.d/mysql restart
to restart MySQL. -
Done!
It looks like you have extra text
to the bottom of the file
to be removed at the end of the instruction in step 2.