ERROR 1054 (42S22): Unknown column ‘Password‘ in ‘field list‘ mysql＞ select user,host,authentication

错误更正

//5.7版本下的MySQL数据库下已经没有password这个字段了
mysql> SELECT User,Host,Password FROM mysql.user;
ERROR 1054 (42S22): Unknown column 'Password' in 'field list'

//将password更改为authentication_string
mysql> select user,host,authentication_string from mysql.user;
+-----------+-----------+-------------------------------------------+
| user      | host      | authentication_string                     |
+-----------+-----------+-------------------------------------------+
| root      | localhost | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |
| mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
+-----------+-----------+-------------------------------------------+
2 rows in set (0.00 sec)