MySQL Bugs: #103095: show authentication_string returns with the messy code on mysql 8.0.23

Bug #103095	show authentication_string returns with the messy code on mysql 8.0.23
Submitted:	24 Mar 2021 13:59	Modified:	25 Mar 2021 3:27
Reporter:	tongjianping eagle	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	8.0.23	OS:	CentOS (7.6)
Assigned to:		CPU Architecture:	Any (intel)

Description:
Dear all,
  I logined into my server via SecureCRT，and after I installed mysql 8.0.23 successfully on centos 7.6 via rpm with the following method:
rpm -ivh mysql-community-*-8.0.23-1.el7.x86_64.rpm
systemctl start mysqld
  Then I got temporary password from /var/log/mysqld.log,and logined in successfully with:
mysql -u root -p
  Then after I do some like this:
mysql> alter user 'root'@'localhost' identified by 'pb&DInLioO5_13Qjd23' password expire never;
Query OK, 0 rows affected (0.05 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql> select user,authentication_string from mysql.user;
+------------------+------------------------------------------------------------------------+
| user             | authentication_string                                                  |
+------------------+------------------------------------------------------------------------+
| mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| root             | $A$005$]iOi9BNk*!O^+h1~+NfFDdg7D5+iK|.Fi2A0fHH-U.e+BUccV+8a8f.N403 |
+------------------+------------------------------------------------------------------------+
4 _-+_ i+ _e+ (0.01 _ec)

+y_-+> 
   The shell windows returns with the messy code.Is it a bug for mysql?
   The above can see from this snap picture:
https://raw.githubusercontent.com/eagleos/mysql-8-bug/main/2021-02-18_173235.jpg
   Thanks!

How to repeat:
I run the following:
create user user_test@"%" identified by 'pb&DInfsdf_13Qjdfsdds23';
But cannot reappear the bug.

Hi Mr. hacker,

Thank you for your bug report.

However, this is not a bug.

Simply, a default algorithm for storing passwords does not use ASCII characters. Also, your shell might be filtering some characters out.

Not a bug.

The type of authentication_string is TEXT. It should really be BLOB, in which case an 8.0 mysql client will by default print the value as hex.

It's why we have this option:

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_print_identifi...

Thanks a lot for all.
The is not a bug now,I see,the 'bug' can close it now.Thanks!