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. 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.

3. Install

Centos 6.7, 6.8, 6.9 and 6.10

3.1 The timezone must be GMT0.
3.2 Installation traces.

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