MySQL在cmd时更改密码时总是出现unknown column'user' in'where clause'

Question

换了一个版本的navicat，连接MySQL把密码忘了
在更改密码的时候已经用的无密登录但是在后面一直有问题
代码
mysql> UPDATE mysql.user SET authentication_string='123456' WHERE user='root' and host='localhost';
ERROR 1054 (42S22): Unknown column 'user' in 'where clause'
mysql> UPDATE mysql.user SET password=PASSWORD('123456')where User='root';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('ROOT')where User='root'' at line 1
另外在查询密码的时候也有问题
代码
mysql> select host,user,password from mysql.user;
ERROR 1054 (42S22): Unknown column 'host' in 'field list'