Mysql

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

2. Install

Centos 6.7, 6.8, 6.9 and 6.10

2.1 The timezone must be GMT0.
2.2 Installation traces.

Ref. http://www.mysql.com/