[MDEV-17427] suggestion in distributed config file can break mysqlbinlog Created: 2018-10-11  Updated: 2023-04-27

Status: Confirmed
Project: MariaDB Server
Component/s: Configuration
Affects Version/s: 5.5, 10.0, 10.1, 10.3.10, 10.2, 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Hartmut Holzgraefe Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Ubuntu



 Description   

The Ubuntu packages come with this snippet in /etc/mysql/mariadb.cnf:

[client]
# Default is Latin1, if you need UTF-8 set this (also in server section)
# default-character-set = utf8

When actually enabling the default character set option by removing the "#" comment sign mysqlbinlog stops working though, as it reads the [client] section, but does not have a --default-character-set option:

mysqlbinlog mariadb-bin.000001 
mysqlbinlog: unknown variable 'default-character-set=utf8'

Possible fixes:

  • explicitly rename the section from [client] to [mysql]
  • add the "loose-" prefix, so that the option gets ignored by binaries that do not have it

Generated at Thu Feb 08 08:36:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.