mysql - 使用shell脚本更改mysql root用户密码

Question

我正在尝试使用如下的 shell 脚本更改用户密码

#!/bin/bash
mysql.server start
mysql -u root << EOF
  SET PASSWORD FOR root@'localhost' = PASSWORD(‘admin’);
EOF

但我收到以下错误:-

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 the right syntax to use near '‘admin’)' at line 1

如果使用其他命令而不是 SET PASSSWORD 命令，则可以像我使用“创建数据库数据库名称”一样工作。

.

Update1:

如果我使用“admin”或“admin”而不是“admin”，则会出现以下错误。

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 the right syntax to use near '“admin2”)' at line 1

.

Update2:

使用 -e 标志时，出现以下错误

./mysql.sh: line 3: syntax error near unexpected token ('
./mysql.sh: line 3:mysql -u root -padmin -e “SET PASSWORD FOR root@'localhost' = PASSWORD(‘admin2’);”'

Answer 1

使用 mysql -e 代替:

#!/bin/bash
mysql.server start
mysql -u root -e "SET PASSWORD FOR root@'localhost' = PASSWORD('admin');"