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. https://rpbouman.blogspot.kr/2014/09/mysql-575-group-by-respects-functional.html

2. MySql 8.x issues

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

3.1 MySQL8 on Ubuntu server 22.04.2

1) The timezone must be GMT0.
2) Installation traces.
3) Check default character set. UTF8(or utf8mb4) required. In case of MySQL8 support utf8mb4. So it is not required.
4) Configuration

3.2 CentOS 6.7, 6.8, 6.9 and 6.10

1) The timezone must be GMT0.
2) Installation traces.

Ref. https://www.mysql.com/