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

Fresh MariaDB 11.4 installation gives errors when configuring utf8

    XMLWordPrintable

Details

    • Can result in unexpected behaviour
    • Q3/2025 Maintenance

    Description

      Hello,

      On a fresh MariaDB 11.4 installation we are unable to configure UTF8 according to the documentation: https://mariadb.com/kb/en/setting-character-sets-and-collations/#example-changing-the-default-character-set-to-utf-8

      After configuring this, we see the following in the mariadb logs:

      Apr 24 11:55:29 debian12 systemd[1]: Started mariadb.service - MariaDB 11.4.5 database server.
      		 
      Apr 24 11:55:29 debian12 /etc/mysql/debian-start[1343646]: Upgrading MariaDB tables if necessary.
      		 
      Apr 24 11:55:30 debian12 /etc/mysql/debian-start[1343716]: Checking for insecure root accounts.
      		 
      Apr 24 11:55:30 debian12 debian-start[1343719]: --------------
      		 
      Apr 24 11:55:30 debian12 debian-start[1343719]: SELECT count(*) FROM mysql.user WHERE user='root' and password='' and password_expired='N' and plugin in ('', 'mysql_native_password', 'mysql_old_password')
      		 
      Apr 24 11:55:30 debian12 debian-start[1343719]: --------------
      		 
      Apr 24 11:55:30 debian12 debian-start[1343719]: ERROR 1267 (HY000) at line 1: Illegal mix of collations (utf8mb4_uca1400_ai_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) for operation '='

      How can we configure UTF8 support in 11.4?

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36619 Collation errors in mariadb-upgrade 10.11 -> 11.4

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24657 Illegal mix of collation errors due to mysql.user having been converted into view

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35686 Collation error utf8mb4_uca1400_ai_ci

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36037 Illegal mix of collations after upgrade from 11.4.4 to 11.4.5

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              nielsh Niels Hendriks
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.