刚开始执行命令:
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';
运行成功!
赠与有缘人,拿走不谢!