Bug #97375 Deprecate and Remove character-set-client-handshake

• Submitted: 25 Oct 2019 5:46
• Modified: 23 Oct 8:06
• Reporter: Meiji Kimura
• Status: Closed
• Category: MySQL Server: Charsets
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[25 Oct 2019 5:46] Meiji Kimura

Description:
--character-set-client-handshake is supported for transition from 4.0 to 4.1.

https://dev.mysql.com/doc/refman/5.6/en/faqs-cjk.html#faq-cjk-how-use-4-0-charset

Almost of all MySQL 3.23/4.0 are gone, so it's time to deprecate/remove this feature.

I think all user using --character-set-client-handshake keeps old my.cnf without that meaning, so When migration from old MySQL to New MySQL, a user should specify charset on their client instead of keeping --character-set-client-handshake in his my.cnf.

How to repeat:
N/A

Suggested fix:
Deprecate character-set-client-handshake in MySQL 8.0.x, and Remove in the future release.

[25 Oct 2019 6:09] MySQL Verification Team

Hello Meiji-San,

Thank you for the report and feedback.

regards,
Umesh

[23 Oct 8:03] MySQL Verification Team

'character-set-client-handshake' was deprecated on MySQL 8.2.0
https://dev.mysql.com/doc/relnotes/mysql/8.2/en/news-8-2-0.html#mysqld-8-2-0-deprecation-r...

The --character-set-client-handshake server option, originally intended for use with upgrades from very old versions of MySQL, is now deprecated, and a warning is issued whenever it is used. You should expect this option to be removed in a future version of MySQL; applications depending on this option should begin migration away from it as soon as possible. (WL #13220)

'character-set-client-handshake' was removed on MySQL 8.3.0
https://dev.mysql.com/doc/relnotes/mysql/8.3/en/news-8-3-0.html#mysqld-8-3-0-deprecation-r...

The --character-set-client-handshake and --old-style-user-limits server options were formerly used for compatibility with very old versions of MySQL which are no longer supported or maintained. Since they no longer serve any useful purpose, both options have been removed. (WL #13221, WL #13229)

So we can close this SR now.

[23 Oct 8:06] MySQL Verification Team

Thank you, Meiji San.

regards,
Umesh