MySQL 7.11 Change Password error 1054 (42S22)

mysql> use MySQL;
Database changed
mysql> Update user Set Password=password (' 123456 ') where user= ' root ';
ERROR 1054 (42S22): Unknown column ' Password ' in ' Field list '
Mysql>

Night by this problem toss for a long time, finally found that window under this version of the MySQL password column is authentication_string, so the correct wording is:

Mysql>update Mysql.user Set Authentication_string=password (' 123456 ') where user= ' root ' and Host = ' localhost ';

Problem solving

MySQL 7.11 Change Password error 1054 (42S22)