mysql 日常报错问题 ERROR 1820 (HY000): You must reset your password

最新推荐文章于 2025-01-14 15:08:58 发布

hbjoan

最新推荐文章于 2025-01-14 15:08:58 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql 数据库文章标签： mysql

本文链接：https://blog.youkuaiyun.com/joanzq/article/details/115065576

mysql 同时被 2 个专栏收录

8 篇文章

订阅专栏

数据库

7 篇文章

订阅专栏

本文介绍了如何在MySQL中重置root用户的密码，并通过SQL命令设置密码永不过期。首先，通过--skip-grant-tables启动MySQL，然后使用ALTER USER命令更新密码并设置EXPIRE NEVER属性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

原因：密码过期，重置密码设置不过期。

解决办法：

mysql> SET PASSWORD = PASSWORD('password123!');

mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

处理过程：

E:\mysql-5.7.19>mysqld --skip_grant_tables;

E:\mysql-5.7.19>mysql -u root -p
Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.7.19

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> alter user 'root'@'localhost'password expire never
-> ;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘root’ PASSWORD EXPIRE NEVER;
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 '‘root’ PASSWORD EXPIRE NEVER' at line 1
mysql> SET PASSWORD = PASSWORD('password123!');
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)

mysql>