Setting up Mysql 8
From Convention Master Documentation
Setting up in Mysql 8
The tasks I had to do to set up CM for mysql 8 were as follows.
- Before the system is even attempted to be installed, log into mysql as the root user sudo mysql and then run the query SET GLOBAL log_bin_trust_function_creators = 1;
- Edit /etc/mysql/mysql.conf.d/mysqld.cnf and add sql-mode="NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" to the end of the file. Then Restart Mysql server