本意向修改一个用户的密码,网上搜到的命令为如下
mysql> update user set password=password(“新密码”) where user=”用户名”;
执行后报错 :ERROR 1054(42S22) Unknown column 'password' in ‘field list’
错误的原因是 5.7版本下的mysql数据库下已经没有password这个字段了,password字段改成了authentication_string
所以请使用一下命令:
-- 修改密码报错
mysql> use mysql
mysql> update user set password=password("*******") where user="*******";
ERROR 1054 (42S22): Unknown column 'password' in 'field list'
-- 修改密码成功
mysql> update user set authentication_string=password('*******') where user='*******';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
-- 刷新数据
flush privileges;
转载: https://www.cnblogs.com/wangbaobao/p/7087032.html