[Solved] MYSQL Start Project Error: this is incompatible with sql_mode=only_full_group_by

1. Error information

2. Edit file

# open the configuration file
vim /etc/my.cnf

# add this line in the end
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

3. Restart MySQL

systemctl restart mysqld

4. Test

# Start
nohup java -jar xxx.jar &

# Checnk the console
tail -f nohup.out

Read More: