[MDEV-38991] mysql system schema using my.cnf(configuration) character set instead of utf8mb3 - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.6, 11.4, 12.3, 11.8.6
Fix Version/s: 10.6
Component/s: None
Labels:
None

Sprint:
Q2/2026 Server Maintenance

Description

10.6:
With Default character Set:

MariaDB [(none)]> SELECT schema_name,DEFAULT_CHARACTER_SET_NAME,default_collation_name FROM information_schema.schemata WHERE schema_name in('sys','information_schema','mysql','performance_schema');

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

| schema_name        | DEFAULT_CHARACTER_SET_NAME | default_collation_name |

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

| information_schema | utf8mb3                    | utf8mb3_general_ci     |

| mysql              | latin1                     | latin1_swedish_ci      |

| performance_schema | utf8mb3                    | utf8mb3_general_ci     |

| sys                | utf8mb3                    | utf8mb3_general_ci     |

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

CNF: CHARACTER_SET_SERVER='utf8mb3' & collation_server='utf8mb3_general_ci'

MariaDB [(none)]> SELECT schema_name,DEFAULT_CHARACTER_SET_NAME,default_collation_name FROM information_schema.schemata WHERE schema_name in('sys','information_schema','mysql','performance_schema');

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

| schema_name        | DEFAULT_CHARACTER_SET_NAME | default_collation_name |

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

| information_schema | utf8mb3                    | utf8mb3_general_ci     |

| mysql              | utf8mb3                    | utf8mb3_general_ci     |

| performance_schema | utf8mb3                    | utf8mb3_general_ci     |

| sys                | utf8mb3                    | utf8mb3_general_ci     |

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

*11.8: *
With Defaults:

MariaDB [(none)]> SELECT schema_name,DEFAULT_CHARACTER_SET_NAME,default_collation_name FROM information_schema.schemata WHERE schema_name in('sys','information_schema','mysql','performance_schema');

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

| schema_name        | DEFAULT_CHARACTER_SET_NAME | default_collation_name |

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

| information_schema | utf8mb3                    | utf8mb3_general_ci     |

| mysql              | utf8mb4                    | utf8mb4_uca1400_ai_ci  |

| performance_schema | utf8mb3                    | utf8mb3_general_ci     |

| sys                | utf8mb3                    | utf8mb3_general_ci     |

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

4 rows in set (0.001 sec)

MariaDB [(none)]> select TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,ENGINE,TABLE_COLLATION from information_schema.TABLES where TABLE_SCHEMA='mysql';

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

| TABLE_SCHEMA | TABLE_NAME                | TABLE_TYPE | ENGINE | TABLE_COLLATION       |

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

| mysql        | db                        | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | global_priv               | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | user                      | VIEW       | NULL   | NULL                  |

| mysql        | roles_mapping             | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | func                      | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | plugin                    | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | servers                   | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | tables_priv               | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | columns_priv              | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | help_topic                | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | help_category             | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | help_relation             | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | help_keyword              | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | time_zone_name            | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | time_zone                 | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | time_zone_transition      | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | time_zone_transition_type | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | time_zone_leap_second     | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | proc                      | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | procs_priv                | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | general_log               | BASE TABLE | CSV    | utf8mb3_general_ci    |

| mysql        | slow_log                  | BASE TABLE | CSV    | utf8mb3_general_ci    |

| mysql        | event                     | BASE TABLE | Aria   | utf8mb3_general_ci    |

| mysql        | innodb_table_stats        | BASE TABLE | InnoDB | utf8mb3_bin           |

| mysql        | innodb_index_stats        | BASE TABLE | InnoDB | utf8mb3_bin           |

| mysql        | transaction_registry      | BASE TABLE | InnoDB | utf8mb3_bin           |

| mysql        | proxies_priv              | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | table_stats               | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | column_stats              | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | index_stats               | BASE TABLE | Aria   | utf8mb3_bin           |

| mysql        | gtid_slave_pos            | BASE TABLE | InnoDB | latin1_swedish_ci     |

| mysql        | server_audit_filters      | BASE TABLE | Aria   | utf8mb4_uca1400_ai_ci |

| mysql        | server_audit_users        | BASE TABLE | Aria   | utf8mb4_uca1400_ai_ci |

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

33 rows in set (0.002 sec)

*CNF: CHARACTER_SET_SERVER='utf8mb3' & collation_server='utf8mb3_general_ci' *

MariaDB [(none)]>  SELECT schema_name,DEFAULT_CHARACTER_SET_NAME,default_collation_name FROM information_schema.schemata WHERE schema_name in('sys','information_schema','mysql','performance_schema');

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

| schema_name        | DEFAULT_CHARACTER_SET_NAME | default_collation_name |

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

| information_schema | utf8mb3                    | utf8mb3_general_ci     |

| mysql              | utf8mb3                    | utf8mb3_general_ci     |

| performance_schema | utf8mb3                    | utf8mb3_general_ci     |

| sys                | utf8mb3                    | utf8mb3_general_ci     |

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

4 rows in set (0.002 sec)

MariaDB [(none)]> select TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,ENGINE,TABLE_COLLATION from information_schema.TABLES where TABLE_SCHEMA='mysql';

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

| TABLE_SCHEMA | TABLE_NAME                | TABLE_TYPE | ENGINE | TABLE_COLLATION    |

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

| mysql        | db                        | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | global_priv               | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | user                      | VIEW       | NULL   | NULL               |

| mysql        | roles_mapping             | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | func                      | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | plugin                    | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | servers                   | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | tables_priv               | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | columns_priv              | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | help_topic                | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | help_category             | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | help_relation             | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | help_keyword              | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | time_zone_name            | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | time_zone                 | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | time_zone_transition      | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | time_zone_transition_type | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | time_zone_leap_second     | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | proc                      | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | procs_priv                | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | general_log               | BASE TABLE | CSV    | utf8mb3_general_ci |

| mysql        | slow_log                  | BASE TABLE | CSV    | utf8mb3_general_ci |

| mysql        | event                     | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | innodb_table_stats        | BASE TABLE | InnoDB | utf8mb3_bin        |

| mysql        | innodb_index_stats        | BASE TABLE | InnoDB | utf8mb3_bin        |

| mysql        | transaction_registry      | BASE TABLE | InnoDB | utf8mb3_bin        |

| mysql        | proxies_priv              | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | table_stats               | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | column_stats              | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | index_stats               | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | gtid_slave_pos            | BASE TABLE | InnoDB | latin1_swedish_ci  |

| mysql        | server_audit_filters      | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | server_audit_users        | BASE TABLE | Aria   | utf8mb3_general_ci |

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

33 rows in set (0.005 sec)

*CNF: CHARACTER_SET_SERVER='latin1' & collation_server='latin1_swedish_ci' *

MariaDB [(none)]> SELECT schema_name,DEFAULT_CHARACTER_SET_NAME,default_collation_name FROM information_schema.schemata WHERE schema_name in('sys','information_schema','mysql','performance_schema');

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

| schema_name        | DEFAULT_CHARACTER_SET_NAME | default_collation_name |

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

| information_schema | utf8mb3                    | utf8mb3_general_ci     |

| mysql              | latin1                     | latin1_swedish_ci      |

| performance_schema | utf8mb3                    | utf8mb3_general_ci     |

| sys                | utf8mb3                    | utf8mb3_general_ci     |

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

4 rows in set (0.001 sec)

MariaDB [(none)]> select TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,ENGINE,TABLE_COLLATION from information_schema.TABLES where TABLE_SCHEMA='mysql';

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

| TABLE_SCHEMA | TABLE_NAME                | TABLE_TYPE | ENGINE | TABLE_COLLATION    |

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

| mysql        | db                        | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | global_priv               | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | user                      | VIEW       | NULL   | NULL               |

| mysql        | roles_mapping             | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | func                      | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | plugin                    | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | servers                   | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | tables_priv               | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | columns_priv              | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | help_topic                | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | help_category             | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | help_relation             | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | help_keyword              | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | time_zone_name            | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | time_zone                 | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | time_zone_transition      | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | time_zone_transition_type | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | time_zone_leap_second     | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | proc                      | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | procs_priv                | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | general_log               | BASE TABLE | CSV    | utf8mb3_general_ci |

| mysql        | slow_log                  | BASE TABLE | CSV    | utf8mb3_general_ci |

| mysql        | event                     | BASE TABLE | Aria   | utf8mb3_general_ci |

| mysql        | innodb_table_stats        | BASE TABLE | InnoDB | utf8mb3_bin        |

| mysql        | innodb_index_stats        | BASE TABLE | InnoDB | utf8mb3_bin        |

| mysql        | transaction_registry      | BASE TABLE | InnoDB | utf8mb3_bin        |

| mysql        | proxies_priv              | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | table_stats               | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | column_stats              | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | index_stats               | BASE TABLE | Aria   | utf8mb3_bin        |

| mysql        | gtid_slave_pos            | BASE TABLE | InnoDB | latin1_swedish_ci  |

| mysql        | server_audit_filters      | BASE TABLE | Aria   | latin1_swedish_ci  |

| mysql        | server_audit_users        | BASE TABLE | Aria   | latin1_swedish_ci  |

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

Attachments

Issue Links

relates to

MDEV-38698 mysql_upgrade does not fix charset and collation for mysql.user

Closed

Activity

People

Assignee:: Rucha Deodhar

Reporter:: Venkata Vigneswara Reddy Bandi

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2026-03-06 08:41

Updated:: 2026-03-10 09:34

Git Integration

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