I have to set a persistent custom SQL MODE persistent to my server.
I added this line in /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
...
sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
When I try to run mysql I get this error:
2020-06-03T09:49:24.567568Z 0 [ERROR] [MY-000077] [Server]
/usr/sbin/mysqld: Error while setting value
'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
to 'sql_mode'. mysqld Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64
((Ubuntu))
I tried to change sql-mode
to sql_mode
and remove the double quotes, but it doesn't change.
Best Answer
Just edit /etc/mysql/my.conf, removing "NO_AUTO_CREATE_USER". The result will be:
It worked for me !