passwords - authentication_string is not output normally in mysql 5.7

Question

I want to print out the account name and password(authentication_string) column at once and see it.

but, It is printed in the following form.

enter image description here

select user, authentication_string from mysql.user;
    +-------+---------------------------------+
| user     | authentication_string              |
+-------+---------------------------------+
| root          | *D7C60FF269438CF469FF6013C46F881B1B345F37          |
| mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE  |
| mysql.sys     | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE   |
| sha256user    | $5$n][lWk
Qnn<q/o6w$D2eNhGMuP/thpHXaqFb59c0a0MOoPnL.xOiQQjtZjp/ |
+---------------+-----------------------+

I want to print sha256user information on 1 line

If anyone knows the answer, please let me know...

question from:https://stackoverflow.com/questions/65932590/authentication-string-is-not-output-normally-in-mysql-5-7

Answer 1

Waitting for answers