ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your

问题：
键入

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

出现：

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to you

针对非root用户修改密码可以是：

use mysql
set password for laoli='123';
flush privileges;

针对root:—目前测试下来仅Linux系统可，Windows系统不可

use mysql
update user set password=password('123456') where user='root';
flush privileges;

关于用户密码可参考忘记mysql root用户密码的解决办法（skip-grant-tables）
https://blog.csdn.net/lxpbs8851/article/details/10895085