ubuntu重置root密码报错

刚开始执行命令:

update user set authentication_string=password('123') where user='root';

报错如下：

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('123') where user='root'' at line 1

命令改为：

update user set authentication_string='123456' where user='root';

运行成功！

赠与有缘人，拿走不谢！