update user set password=password("123456") where user="root";

ERROR 1054 (42S22): Unknown column 'password' in 'field list'


 update user set authentication_string=PASSWORD("123456") where User="root";

Query OK, 1 row affected, 1 warning (0.00 sec)

Rows matched: 1  Changed: 1  Warnings: 1

flush privileges


mysql的5.7.28版本更新密码的字段已经变化为:authentication_string了。原来的password已经失效了。