Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.4
-
None
Description
The 50-client.cnf configuration file on Debian/Ubuntu currently sets default-character-set:
$ cat /etc/mysql/mariadb.conf.d/50-client.cnf
|
#
|
# This group is read by the client library
|
# Use it for options that affect all clients, but not the server
|
#
|
|
[client]
|
# Default is Latin1, if you need UTF-8 set this (also in server section)
|
default-character-set = utf8mb4
|
|
# Example of client certificate usage
|
# ssl-cert=/etc/mysql/client-cert.pem
|
# ssl-key=/etc/mysql/client-key.pem
|
#
|
# Allow only TLS encrypted connections
|
# ssl-verify-server-cert=on
|
|
# This group is *never* read by mysql client library, though this
|
# /etc/mysql/mariadb.cnf.d/client.cnf file is not read by Oracle MySQL
|
# client anyway.
|
# If you use the same .cnf file for MySQL and MariaDB,
|
# use it for MariaDB-only client options
|
[client-mariadb]
|
Not all clients support the default-character-set option, so this causes errors when those clients are used. For example, mysqlbinlog doesn't support it:
$ mysqlbinlog --help
|
mysqlbinlog: unknown variable 'default-character-set=utf8mb4'
|
And neither does mysqlslap:
$ mysqlslap --help
|
mysqlslap: unknown variable 'default-character-set=utf8mb4'
|
This option should not be in the [client] option group, since not all clients support it.
Attachments
Issue Links
- blocks
-
MDEV-19123 Change default charset from latin1 to utf8mb4
-
- Closed
-
- is duplicated by
-
MDEV-24006 mysqlbinlog command does not work on new MariaDB 10.5.6 install
-
- Closed
-
- relates to
-
MDEV-22982 Client --help options break when configuration files contain unknown options
-
- Open
-
Activity
Field | Original Value | New Value |
---|---|---|
Summary | Bad option in 50-client.cnf on Debian/Ubuntu | Bad "default-character-set" option in [client] group 50-client.cnf on Debian/Ubuntu |
Link | This issue relates to MDEV-22982 [ MDEV-22982 ] |
Component/s | Configuration [ 13904 ] |
Summary | Bad "default-character-set" option in [client] group 50-client.cnf on Debian/Ubuntu | Bad "default-character-set" option in [client] option group 50-client.cnf on Debian/Ubuntu |
Priority | Major [ 3 ] | Blocker [ 1 ] |
Fix Version/s | 10.5.4 [ 24264 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Assignee | Sergei Golubchik [ serg ] | Oleksandr Byelkin [ sanja ] |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Resolution | Fixed [ 1 ] | |
Status | Closed [ 6 ] | Stalled [ 10000 ] |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.5.4 [ 24264 ] |
Link |
This issue blocks |
Assignee | Oleksandr Byelkin [ sanja ] |
Priority | Blocker [ 1 ] | Major [ 3 ] |
Assignee | Otto Kekäläinen [ otto ] |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Link | This issue relates to MENT-877 [ MENT-877 ] |
Link |
This issue is duplicated by |
Fix Version/s | 10.5.4 [ 24264 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 110342 ] | MariaDB v4 [ 158005 ] |