Bug #98923 Can not change system variable collation_connection in init_connect param

• Submitted: 12 Mar 2020 10:01
• Modified: 12 Mar 2020 11:09
• Reporter: 文静 刘
• Status: Duplicate
• Category: MySQL Server: Charsets
• Severity: S3 (Non-critical)
• Version: 8.0.19
• OS: Windows (Windows 10 Enterprise)
• CPU Architecture: x86
• Tags: collation_connection;init_connect

[12 Mar 2020 10:01] 文静 刘

Description:
Can not change system variable collation_connection in init_connect param in my.ini

How to repeat:
install MySQL 8.0.19 using mysql-installer-community-8.0.19.0.msi
create a new user test as non-super user, login in Workbench
run
show variables like '%collat%';
the result is :
collation_connection	utf8mb4_0900_ai_ci
collation_database	utf8mb4_0900_ai_ci
collation_server	utf8mb4_0900_ai_ci
default_collation_for_utf8mb4	utf8mb4_0900_ai_ci

add init_connect='SET collation_server = utf8mb4_general_ci;SET collation_database = utf8mb4_general_ci;SET collation_connection = utf8mb4_general_ci' below [mysqld], and restart service and relogin use user test and run
show variables like '%collat%';
the result is:
collation_connection	utf8mb4_0900_ai_ci
collation_database	utf8mb4_general_ci
collation_server	utf8mb4_general_ci
default_collation_for_utf8mb4	utf8mb4_0900_ai_ci

[12 Mar 2020 11:09] MySQL Verification Team

Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=18304.