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 'mysql> ALTER USER root@localhost IDENTIFIED BY ‘root’
解决
语句使用错误,8.0.11版本下修改密码语句为
ALTERUSER'root'@'localhost' identified by '123456' ;
MySql8.0.11密码无法修改问题提示解决提示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 'mysql> ALTER USER root@localhost IDENTIFIED BY ‘root’解决语句使用错误,8.0.11版