Fix Solved "Error Code: 1055 incompatible with sql only_full_group_by" Server GNU/Linux
https://www.gagaltotal666.my.id/2020/...
setting file mysqld.cnf in directory /etc/mysql/mysql.conf.d/
Add this to the end of the file [mysqld] on Ubuntu Server 18.04 :
[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"
Solved on Ubuntu server 20.04 Focal Fossa :
[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
save... and done....
#FixError #ErrorCode1055 #ServerGNULinux #SQLServerMysql