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.

2. MySql 8.x issue

2.1 "Authentication plugin 'caching_sha2_password' cannot be loaded" error
Please refer to
2.2 "Could not retrieve transaction read-only status server" error
You need to add "&useLocalSessionState=true" at JDBC url.

3. Install

Centos 6.7, 6.8, 6.9 and 6.10

3.1 The timezone must be GMT0.
3.2 Installation traces.