Mac 安装 MySQL 5.7 后登入后无法执行命令【You must reset your password using ALTER USER statement before executing...

最新推荐文章于 2023-12-07 15:25:12 发布

weixin_34324081

最新推荐文章于 2023-12-07 15:25:12 发布

阅读量86

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/zacky31/p/9121302.html

版权

今天在 Mac 上安装了 MySQL 5.7 ，启动服务后，输入 mysql -u root -p 后，输入初始密码程，尝试执行 show databases;

报了一个 You must reset your password using ALTER USER statement before executing this statement. 错误。

参考 Stack Overflow 上一篇文章 https://stackoverflow.com/questions/33467337/reset-mysql-root-password-using-alter-user-statement-after-install-on-mac

步骤如下：

set password = password('your new password');

alter user 'root'@'localhost' password expire never;

flush privileges;

转载于:https://www.cnblogs.com/zacky31/p/9121302.html

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

weixin_34324081

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

mysql5.7初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before

夫君子之行,静以修身,俭以养德,非淡泊无以明志,非宁静无以致远.

01-02

327

mysql初始化密码常见报错问题 1，mysql5.6是密码为空直接进入数据库的，但是mysql5.7就需要初始密码 cat /var/log/mysqld.log | grep password 2，然后执行 mysql -uroot -p ，输入上面的到的密码进入，用该密码登录后，必须马上修改新的密码，不然会报如下错误： mysql> use mysql; ERROR 1...

关于mysql密码过期策略出现ERROR 1820 (HY000): You must reset your password using ALTER USER statement before ex

小飞哥的博客

04-13

873

关于mysql密码过期策略导致无法执行语句问题解决方案： 1.今天忽然间mysql远程无法登录，去服务器查看登录正常，但是无法执行语句，提示报这样的错误： ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 提示说：您必...

参与评论您还未登录，请先登录后发表或查看评论

mac mysql error You must reset your password using ALTER USER statement before executing this statem...

weixin_34214500的博客

12-02

179

安装完mysql 之后，登陆以后，不管运行任何命令，总是提示这个 step 1:SET PASSWORD = PASSWORD('your new password'); step 2:ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER; step 3:flush privileges; 完成以上三步退出再登，使用新设置的密码就行了...

转载-重设 Mysql 密码报错 You must reset your password ... 和 Your password does N

Jamin2018的博客

01-17

1273

原文：http://blog.sina.com.cn/s/blog_a0d71a9d0102wlz3.html 如果MySQL数据库用户的密码设置过于简单，数据库在用户登录后会提示重置密码，并且不接受简单的密码。提示需要重置密码： ERROR 1820 (HY000): You must reset your password using ALTER USERstatement bef

mysql报错：You must reset your password using ALTER USER statement before executing this statement....

weixin_30657541的博客

09-17

1709

新安装mysql后，登录后，执行任何命令都会报错： You must reset your password using ALTER USER statement before executing this statement. 【解决办法】 MySQL版本5.7.6版本以前用户可以使用如下命令： mysql> SET PASSWORD = PASSWOR...

mysql5.7 You must reset your password using ALTER USER statement before executing this statement.

liwei2633的专栏

05-20

5243

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 参考自:https://dev.mysql.com/doc/refman/5.7/en/alter-user.html 需要用ALTER USER重置一次密码才能执行sql语句，

安装MYSQL5.7报错： mysql】You must reset your password using ALTER USER statement before executing this

qq_44660367的博客

08-01

483

翻译过来就是：需要先使用ALTER USER 修改密码。后才能使用MYSQL。 mysql> SET PASSWORD = PASSWORD('123456'); 执行上面语句可能会报如下错误： Your password does not satisfy the current policy requirements 修改mysql密码出现的错误解决方式： set global validate_password_policy=0; set global validate_password

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

weixin_43520450的博客

07-20

3529

刚安装好mysql修改初始化密码会出现的错误提示 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 1、mysql5.7需要初始密码，先查看初始化密码： cat /var/log/mysqld.log | grep password 2、执行 mysql -uroot -p'初始化密码'，登陆mysql mysql -uroot -p'

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

civil的专栏

11-17

6807

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

解决centos8 MySQL密码问题ERROR 1820 (HY000) You must reset your password using ALTER USER

m0_67394230的博客

07-30

608

先自我介绍一下，小编13年上师交大毕业，曾经在小公司待过，去过华为OPPO等大厂，18年进入阿里，直到现在。深知大多数初中级java工程师，想要升技能，往往是需要自己摸索成长或是报班学习，但对于培训机构动则近万元的学费，着实压力不小。因此我收集了一份《java开发全套学习资料》送给大家，初衷也很简单，就是希望帮助到想自学又不知道该从何学起的朋友，同时减轻大家的负担。最后ps我用的centos8.5.2111MySQL8如果是MySQL5的修改密码等级期限的语句会有区别。...

mysql5.7免安装版报错处理You must reset your password using ALTER USER statement before executing

m0_61436250的博客

09-02

193

安装完mysql 之后，登陆以后，不管运行任何命令，总是提示这个 step 1:SET PASSWORD = PASSWORD('your new password'); step 2:ALTER USER 'root'@'localhost'PASSWORD EXPIRE NEVER; step 3:flush privileges; 完成以上三步退出再登，使用新设置的密码就行了，以上除了红色的自己修改成新密码外，其他原样输入即可 ...

Mysql5.7错误：ERROR 1820 (HY000): You must reset your password using ALTER USER statement before execut...

weixin_34237596的博客

01-23

156

为什么80%的码农都做不了架构师？>>> ...

mysql 5.7 You must reset your password using ALTER USER statement before executing this statement.

最新发布

yeyuningzi的博客

12-07

812

mysql 5.7.44 环境里已经初始化数据库完成，通过初始化密码 mysql -uroot -p 登录，但是在执行sql时报错：ERROR 1820 （HY000）: You must reset your password using ALTER USER statement before executing this statement.

mysql 5.7 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executi

红豆的编程空间

05-16

201

登陆了MySQL报错大概是密码过期了要你重置密码。 SET PASSWORD = PASSWORD('123456'); 详细参考文章 https://blog.csdn.net/keketrtr/article/details/50886374

mysql5.7报错过期,mysql5.7报错You must reset your password using ALTER USER statement before executing thi...

weixin_36278346的博客

03-23

1395

mysql> alter user user() identified by 'Aa123456';Query OK, 0 rows affected (0.01 sec)原因：这是mysql的密码策略过期导致解决办法：配置mysql的配置文件来修改过期策略过期策略修改为120天[mysqld]default_password_lifetime=120如果要设置密码永不过期，my.cnf配置...

mac mysql error You must reset your password using ALTER USER statement before executing this statem

frank_wu的专栏

12-18

711

mysql5.7.15安装后报错You must reset your password using ALTER USER statement before executing this statem

PHP于老师的博客

08-28

1018

mysql5.7.15安装后报错You must reset your password using ALTER USER statement before executing this statem 原因：mysql5.7 在第一次执行 mysql -uroot -p ，输入密码进入后，必须马上修改新的密码解决： alter user 'root' identified by '12...

MySQL 8 You must reset your password using ALTER USER statement before executing this statement.

08-27

In MySQL 8, when you first install the server or reset the root password, you will see the message "You must reset your password using ALTER USER statement before executing this statement.". This is a security feature to ensure that the root password is set before any other operations are performed. To resolve this issue, you need to use the ALTER USER statement to set a new password for the root user. Here's an example of how you can do it: ```sql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password'; ``` Replace `'new_password'` with the actual password you want to set. After executing this statement, you will be able to proceed with other SQL statements. Please note that it's important to choose a strong password to ensure the security of your MySQL server.