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 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.