ERROR 1064 (42000): You have an error in your SQL syntax;

【Mysql 8.x】
Mysq 命令 SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD<‘123456’>;执行错误：
ERROR 1064 (42000): You have an error in your SQL syntax;

改为：SET PASSWORD FOR ‘root’@‘localhost’ = ‘123456’;