1. MySql 5.7 issue
MySQL 5.7.5+ changed the way GROUP BY behaved in order to be SQL99 compliant (where in previous versions it was not).
ProPTT2 server 1.4.1 and below has this issue.
Do: Ref. http://rpbouman.blogspot.kr/2014/09/mysql-575-group-by-respects-functional.html
Centos 6.7, 6.8, 6.9 and 6.102.1 The timezone must be GMT0.
2.2 Installation traces.