Talk:EPrints and MySQL 8

From EPrints Documentation

Jump to: navigation, search

This setting is giving me an error in mysql8: sql_mode = NO_AUTO_CREATE_USER I don't think this is a valid setting in either MySQL or MariaDB?

In addition, I get this warning about the other settings:

'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

Should we include the following in the sql_mode command/setting: STRICT_TRANS_TABLES ?

Retrieved from ‘https://wiki.eprints.org/w/index.php?title=Talk:EPrints_and_MySQL_8&oldid=16087’