使用cmd命令行修改数据库用户账号和密码

ERROR 1054 (42S22): Unknown column ‘password’ in 'field list’报错！！！
前提：在已登录账号密码的情况下！
修改账号：

mysql> Use mysql;
mysql> Select user From User;
mysql> Update user Set user='新账号' Where user='旧账号';
mysql> Flush Privileges;
mysql> Exit

修改密码：

mysql> Use mysql;
mysql> Select user From User;
mysql> Update user Set password=Password('新密码') Where user='账号名'; 

出现ERROR 1054 (42S22): Unknown column ‘password’ in ‘field list’

mysql> Update mysql.user Set authentication_string=Password('新密码') Where user='账号名';
mysql> Flush Privileges;
mysql> Exit

修改数据库用户账号和密码完成！