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)
• Status: Closed
• Category: MySQL Server: Replication
• Severity: S2 (Serious)
• Version: 8.0.11
• OS: Any
• 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.