Bug #119084 The initial default values ​​of the character_set_connection GLOBAL variable and the SESSION variable are inconsistent

• Submitted: 27 Sep 14:14
• Modified: 29 Sep 17:27
• Reporter: Fuzz CS
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[27 Sep 14:14] Fuzz CS

Description:
docker run --restart=always  --name mysqllts -e MYSQL_ROOT_PASSWORD=123456  -d mysql:lts

mysql> SHOW GLOBAL VARIABLES LIKE 'character_set_connection';
+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| character_set_connection | utf8mb4 |
+--------------------------+---------+
1 row in set (0.00 sec)

mysql> SHOW SESSION VARIABLES LIKE 'character_set_connection';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| character_set_connection | latin1 |
+--------------------------+--------+
1 row in set (0.01 sec)

How to repeat:
docker run --restart=always  --name mysqllts -e MYSQL_ROOT_PASSWORD=123456  -d mysql:lts

mysql> SHOW GLOBAL VARIABLES LIKE 'character_set_connection';
+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| character_set_connection | utf8mb4 |
+--------------------------+---------+
1 row in set (0.00 sec)

mysql> SHOW SESSION VARIABLES LIKE 'character_set_connection';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| character_set_connection | latin1 |
+--------------------------+--------+
1 row in set (0.01 sec)

[29 Sep 17:27] MySQL Verification Team

Hi,

I do not see how is this a bug. Session value of the charsetconnection is set by the client.