MySQL 5.7 修改密码出错 Unknown column 'password' in 'field list'

mysql> update user set password=password("*******") where user=“root”;
ERROR 1054 (42S22): Unknown column ‘password’ in ‘field list’

解决方法：
将第一个password字段替换成authentication_string

mysql> update user set authentication_string=password("********") where user=“root”;
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1

参考: Mysql5.7.18.1修改用户密码报错ERROR 1054 (42S22): Unknown Column ‘Password’ In 'Field List’解决办法.