mysql 错误 1064 哪里

Question

我需要帮助...尝试为 mysql 设置密码

我开始创建一个用户:它成功了!

mysql> CREATE USER admin@localhost;
Query OK, 0 rows affected (0.02 sec)

我正在尝试分配密码，但这不起作用，并且收到以下错误:

mysql> UPDATE mysql.user SET authentication_string = PASSWORD <'PHP1234'> WHERE USER = 'admin';

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 'WHERE USER = 'admin'' at line 1

您能否帮助解决我收到的错误消息或我需要如何编写它？

Answer 1

尖括号应该是圆括号您可以使用以下两种语法为用户设置密码:

UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER='user-name-here' AND Host='host-name-here';

或

SET PASSWORD FOR 'user-name-here'@'hostname-name-here' = PASSWORD('new-password-here');