mysql 1054(42S22)错误

2026-02-14 03:09:48

1、输入以下命令报错mysql> UPDATE user SET password=PASSWORD(‘newpasswd’)WHERE user=’root’;

mysql 1054(42S22)错误

2、重新输入mysql>update mysql.user set authentication_string=password('123qwe') where user='root' and Host ='localhost';

如下图,问题解决。

mysql 1054(42S22)错误

猜你喜欢