Bug #102083 print_identified_with_as_hex functionality for mysqlbinlog
Submitted: 29 Dec 2020 9:59 Modified: 29 Dec 2020 10:27
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S4 (Feature request)
Version:8.0.21 OS:Any
Assigned to: CPU Architecture:Any
Tags: caching_sha2, usability

[29 Dec 2020 9:59] Daniël van Eeden
Description:
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_print_identifi...

The `IDENTIFIED WITH 'caching_sha2_password' AS...` for `caching_sha2_password` contains binary data in the output of `mysqlbinlog`. For MySQL server the `print_identified_with_as_hex` variable was added to allow hex literals instead of binary data. 

How to repeat:
See description

Suggested fix:
Add hex literal output for identified with for mysqlbinlog
[29 Dec 2020 10:27] MySQL Verification Team
Hello Daniël,

Thank you for the reasonable feature request!

regards,
Umesh