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. MySql 8.x issue
2.1 "Authentication plugin 'caching_sha2_password' cannot be loaded" error
Please refer to https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded
2.2 "Could not retrieve transaction read-only status server" error
You need to add "&useLocalSessionState=true" at JDBC url.
Centos 6.7, 6.8, 6.9 and 6.103.1 The timezone must be GMT0.
3.2 Installation traces.