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’解决办法.