Short answer
In config\database.php –> "mysql" array
Set 'strict' => false to disable all.
…. or
You can leave 'strict' => true and add modes to "mysql" option in
'mysql' => [
...
....
'strict' => true,
'modes' => [
//'ONLY_FULL_GROUP_BY', // Disable this to allow grouping by one column
'STRICT_TRANS_TABLES',
'NO_ZERO_IN_DATE',
'NO_ZERO_DATE',
'ERROR_FOR_DIVISION_BY_ZERO',
'NO_AUTO_CREATE_USER',
'NO_ENGINE_SUBSTITUTION'
],
]
Detailed answer
You may not need to disable all strict options …
Kindly have a look on this answer about this issue.