MySQL:尝试为 root 设置密码，SQL 语法错误

Question

这段代码来自Learning MySQL and MariaDB一书:

mysql -u root -p -e "SET PASSWORD FOR 'root'@'127.0.0.1' PASSWORD('new_pwd');"

我收到这个错误:

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
e right syntax to use near 'PASSWORD('new_pwd')' at line 1

这本书对吗？这个语法是不是很旧？有什么问题？

Answer 1

尝试:

mysql -u root -p -e "SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('new_pwd');"