Mysql创建过程时出现1820错误

Question

我在使用 mysql 创建过程时遇到了一个问题。我使用“root@localhost”来创建程序。命令执行成功。之后，我删除了过程 A 并想使用“root@127.0.0.1”创建 A，然后遇到错误:1820 - You must SET PASSWORD before executing this statement。

其实我已经为此设置了密码，但仍然错误。其他程序使用“root@127.0.0.1”均成功无误。该问题仅在 A 上面临。

据我所知，这个错误通常出现在创建数据库时。但是这次...:(

谁能帮帮我？非常感谢!!!

Answer 1

权利来自 the manual :

After an account's password has been expired, all operations performed in subsequent connections to the server using the account result in an error until the user issues a SET PASSWORD statement to establish a new account password:

mysql> SELECT 1;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

mysql> SET PASSWORD = PASSWORD('new_password');
Query OK, 0 rows affected (0.01 sec)

mysql> SELECT 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)