当前位置：网站首页>mysql 忘记root密码后 ERROR 1054 (42S22): Unknown column 'Password' in 'field list'

mysql 忘记root密码后 ERROR 1054 (42S22): Unknown column 'Password' in 'field list'

2022-08-08 21:22:00 【lhf2112】

mysql 忘记root密码后修改密码，发现update无法对password进行操作，并报出：ERROR 1054 (42S22): Unknown column 'Password' in 'field list'

大神答案：update mysql.user set authentication_string=password('123qwe') where user='root' and Host ='localhost'; 即用authentication_string替换了password。

版权声明
本文为[lhf2112]所创，转载请带上原文链接，感谢
https://blog.csdn.net/lhf2112/article/details/52079065