Setting up Mysql 8: Difference between revisions
From Convention Master Documentation
(Created page with "== 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...") |
(No difference)
|
Revision as of 17:06, 15 November 2022
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