Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22981

Bad "default-character-set" option in [client] option group 50-client.cnf on Debian/Ubuntu

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              otto Otto Kekäläinen
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: