Wednesday, September 2, 2020

MYSQL strict mode issue resolved but each and every time server restart need to run the below commands

 If you set globals in MySQL:

SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';

SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION';

This will not set it PERMANENTLY, and it will revert after every restart.

So you should set this in your config file (e.g. /etc/mysql/my.cnf in the [mysqld] section), so that the changes remain in effect after MySQL restart:

Config File: /etc/mysql/my.cnf

MYSQL Restart: sudo service apache2 restart

No comments:

Post a Comment