执行了ALTER USER 'root@localhost' IDENTIFIED WITH mysql_native password BY 'test';，报错：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 ‘BY ‘test’’ at line 1
mysql> update mysql.user set authentication_string=password(‘test’) where user=“root” and Host=“localhost”;
执行了update mysql.user set authentication_string=password('kylin_mysql') where user='root' and Host ='localhost';，也是同样的报错，也没办法修改数据库的密码，后来找到了解决方法，一试就成功了。感谢！
原文链接：https://www.ngui.cc/article/show-313441.html