Mysql restores ONLY_FULL_GROUP_BY after restart

Mysql restores ONLY_FULL_GROUP_BY after restart


I must add a new line into /etc/mysql/mysql.conf.d/mysqld.cnf
At the end of the section [mysqld], I added
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Then restarted
sudo systemctl restart mysql
My settings now is preserved after restart.

Popular posts from this blog

How to receive JSON object in POST and GET using web api

How To Migrate MVC 3 Application To MVC 5

Building a CRUD Application with Ag-Grid