1、输入以下命令报错mysql> UPDATE user SET password=PASSWORD(‘newpasswd’)WHERE user=’root’;
2、重新输入mysql>update mysql.user set authentication_string=password('123qwe') where user='root' and Host ='localhost';如下图,问题解决。
时间:2024-10-28 04:58:15
1、输入以下命令报错mysql> UPDATE user SET password=PASSWORD(‘newpasswd’)WHERE user=’root’;
2、重新输入mysql>update mysql.user set authentication_string=password('123qwe') where user='root' and Host ='localhost';如下图,问题解决。