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] MySQL Verification Team
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...
[28 Oct 2022 15:24] Simon Mudd
Still affecting me in 8.0.31.

Using the set persist functionality is complicated because I already check configuration settings in /etc/my.cnf and dynamically reconfigure the server where possible based on the server's current settings.

Having to include and or maintain set persist settings in addition to the on disk /etc/my.cnf settings makes configuration management more complex and is not appealing.