MySQL 配置文件设置 sql_mode失败

cat /var/log/mysql/error.log

Error while setting value 'ONLY_FULL_GROUP_BY, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.

Just edit /etc/mysql/my.conf, removing "NO_AUTO_CREATE_USER". The result will be:

! includedir /etc/mysql/conf.d/
! includedir /etc/mysql/mysql.conf.d/

[mysqld]
sql_mode = "STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"

It worked for me !

以上来自: https://serverfault.com/questions/1019823/cannot-set-sql-mode-to-mysql-8