Bug #90719 default_collation_for_utf8mb4 can't be set from configuration file
Submitted: 2 May 2018 13:37 Modified: 28 May 2018 12:14
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:8.0.11 OS:Any
Assigned to: CPU Architecture:Any

[2 May 2018 13:37] Daniël van Eeden
Description:
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_collat... 
"Command-Line Format 	--default-collation-for-utf8mb4=value"

Putting this in /etc/my.cnf like this doesn't work
default_collation_for_utf8mb4 = 'utf8mb4_general_ci'

mysqld --help --verbose 2>&1 | grep utf8mb4 doesn't show the setting

Workaround: use SET PERSIST

How to repeat:
Try to set default utf8mb4 collation via /etc/my.cnf and/or mysqld arguments

Suggested fix:
Allow this to be configured via my.cnf
[3 May 2018 5:14] Umesh Shastry
Hello Daniël,

Thank you for the report!

Thanks,
Umesh
[28 May 2018 12:14] Paul Dubois
Posted by developer:
 
Documentation has been updated:

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_collat...