mysql - GRANTPRIVILEGES 是否会覆盖现有的用户和密码？

Question

执行以下命令:

GRANT ALL PRIVILEGES ON myblog.* TO "wordpress"@"localhost" IDENTIFIED BY "summer";

如果执行，设置一个新密码，当已经有一个密码为winter的现有用户wordpress？

Answer 1

是的，确实如此。

When the IDENTIFIED BY clause is present and you have global grant privileges, the password becomes the new password for the account, even if the account exists and already has a password. With no IDENTIFIED BY clause, the account password remains unchanged.

引自MySQL documentation