Configurando SET GLOBAL no MySQL
Edite
sudo vim /etc/mysql/conf.d/
[mysql]
SET GLOBAL sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
MYSQL config 0000-00-00 date format and
Group by
ONLY_FULL_GROUP_BY