Illegal mix of collations after upgrade from 11.4.4 to 11.4.5

Feb 06 07:32:56 dev.server.com systemd[1]: Started mariadb.service - MariaDB 11.4.5 database server.

Feb 06 07:32:56 dev.server.com /etc/mysql/debian-start[164206]: Upgrading MariaDB tables if necessary.

Feb 06 07:32:57 dev.server.com debian-start[164223]: --------------

Feb 06 07:32:57 dev.server.com debian-start[164223]: SELECT count(*) FROM mysql.user WHERE user='root' and password='' and password_expired='N' and plugin in ('', 'mysql_native_password', 'mysql_old_password')

Feb 06 07:32:57 dev.server.com debian-start[164223]: --------------

Feb 06 07:32:57 dev.server.com debian-start[164223]: ERROR 1267 (HY000) at line 1: Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_uca1400_ai_ci,COERCIBLE) for operation '='

MariaDB [(none)]> SELECT count(*) FROM mysql.user WHERE user = 'root' COLLATE utf8mb4_general_ci   AND password = '' COLLATE utf8mb4_general_ci   AND password_expired = 'N'   AND plugin COLLATE utf8mb4_general_ci IN ('', 'mysql_native_password', 'mysql_old_password');

ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_uca1400_ai_ci,COERCIBLE) for operation '='

MariaDB [(none)]> SHOW VARIABLES LIKE 'collation%';

+----------------------+-----------------------+

| Variable_name        | Value                 |

+----------------------+-----------------------+

| collation_connection | utf8mb4_uca1400_ai_ci |

| collation_database   | utf8mb4_unicode_ci    |

| collation_server     | utf8mb4_unicode_ci    |

+----------------------+-----------------------+

3 rows in set (0.001 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'character_set%';

+--------------------------+-------------------------------+

| Variable_name            | Value                         |

+--------------------------+-------------------------------+

| character_set_client     | utf8mb4                       |

| character_set_collations | utf8mb4=utf8mb4_uca1400_ai_ci |

| character_set_connection | utf8mb4                       |

| character_set_database   | utf8mb4                       |

| character_set_filesystem | binary                        |

| character_set_results    | utf8mb4                       |

| character_set_server     | utf8mb4                       |

| character_set_system     | utf8mb3                       |

| character_sets_dir       | /usr/share/mariadb/charsets/  |

+--------------------------+-------------------------------+

9 rows in set (0.001 sec)

MariaDB [(none)]> SHOW FULL COLUMNS FROM mysql.user;

+------------------------+---------------------+--------------------+------+-----+----------+-------+---------------------------------+---------+

| Field                  | Type                | Collation          | Null | Key | Default  | Extra | Privileges                      | Comment |

+------------------------+---------------------+--------------------+------+-----+----------+-------+---------------------------------+---------+

| Host                   | char(255)           | utf8mb3_bin        | NO   |     |          |       | select,insert,update,references |         |

| User                   | char(128)           | utf8mb3_bin        | NO   |     |          |       | select,insert,update,references |         |

| Password               | longtext            | utf8mb4_bin        | YES  |     | NULL     |       | select,insert,update,references |         |

| Select_priv            | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Insert_priv            | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Update_priv            | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Delete_priv            | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Create_priv            | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Drop_priv              | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Reload_priv            | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Shutdown_priv          | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Process_priv           | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| File_priv              | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Grant_priv             | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| References_priv        | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Index_priv             | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Alter_priv             | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Show_db_priv           | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Super_priv             | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Create_tmp_table_priv  | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Lock_tables_priv       | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Execute_priv           | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Repl_slave_priv        | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Repl_client_priv       | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Create_view_priv       | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Show_view_priv         | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Create_routine_priv    | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Alter_routine_priv     | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Create_user_priv       | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Event_priv             | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Trigger_priv           | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Create_tablespace_priv | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| Delete_history_priv    | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| ssl_type               | varchar(9)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| ssl_cipher             | longtext            | utf8mb4_bin        | NO   |     |          |       | select,insert,update,references |         |

| x509_issuer            | longtext            | utf8mb4_bin        | NO   |     |          |       | select,insert,update,references |         |

| x509_subject           | longtext            | utf8mb4_bin        | NO   |     |          |       | select,insert,update,references |         |

| max_questions          | bigint(20) unsigned | NULL               | NO   |     | 0        |       | select,insert,update,references |         |

| max_updates            | bigint(20) unsigned | NULL               | NO   |     | 0        |       | select,insert,update,references |         |

| max_connections        | bigint(20) unsigned | NULL               | NO   |     | 0        |       | select,insert,update,references |         |

| max_user_connections   | bigint(21)          | NULL               | NO   |     | 0        |       | select,insert,update,references |         |

| plugin                 | longtext            | utf8mb4_bin        | NO   |     |          |       | select,insert,update,references |         |

| authentication_string  | longtext            | utf8mb4_bin        | NO   |     |          |       | select,insert,update,references |         |

| password_expired       | varchar(1)          | utf8mb4_general_ci | NO   |     |          |       | select,insert,update,references |         |

| is_role                | varchar(1)          | utf8mb4_general_ci | YES  |     | NULL     |       | select,insert,update,references |         |

| default_role           | longtext            | utf8mb4_bin        | NO   |     |          |       | select,insert,update,references |         |

| max_statement_time     | decimal(12,6)       | NULL               | NO   |     | 0.000000 |       | select,insert,update,references |         |

+------------------------+---------------------+--------------------+------+-----+----------+-------+---------------------------------+---------+

47 rows in set (0.002 sec)