mysql8初始化后用户密码修改

椰果子

于 2021-03-28 14:53:28 发布

阅读量414

点赞数

文章标签： mysql

本文链接：https://blog.youkuaiyun.com/A15937822658/article/details/115280864

版权

在新初始化的MySQL登录后，遇到错误1820，提示必须使用ALTER USER语句重置密码。尝试使用`set password for root@localhost = password('root')`和`alter user root set pawwsord=PASSWORD('root123456')`命令时，分别出现语法错误。最终通过`alter user 'root'@'localhost' identified by 'root123456';`成功设置了新密码。

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

新初始化登陆后，执行show databases 提示：

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

执行 set password for root@localhost = password('root')；

有如下报错：

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 'database' at line 1

改用： alter user root set pawwsord=PASSWORD('root123456');有另一个报错：

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 'set pawwsord=PASSWORD('root123456')' at line 1

改用：alter user 'root'@'localhost' identified by 'root123456';

执行成功。