Configuring MySQL 8
Terminalfour 8.3.14 introduced support for MySQL 8.0. Below is some guidance on configuring it if you are self-hosted.
Database table engine, collations, and charset
| Table Engine | InnoDB is the preferred and supported database table engine for MySQL 5.7 and MySQL 8.0. All tables should be using InnoDB. |
|---|---|
| CHARSET | utf8mb4* |
| COLLATE | utf8mb4_0900_ai_ci |
*utf8mb3 should not be used
Ensure that the character sets are set correctly on the database
In my.cnf (Linux) or my.ini (Windows), edit the file, and add the following:
[mysql]
default-character-set=utf8mb4
[mysqld]
character-set-server=utf8mb4MySQL JDBC
The newer version of the JDBC driver must be used and placed into Tomcat's lib directory.
Tomcat server.xml
Some changes are required to the Tomcat server.xml file
Resource driverClassName
<!--This class path works but it is deprecated and should be changed-->
driverClassName="com.mysql.jdbc.Driver"
<!--Change it to the following, note the "cj"-->
driverClassName="com.mysql.cj.jdbc.Driver"