ERROR 1820 (HY000): You must SET PASSWORD before e

最新推荐文章于 2024-08-12 15:56:33 发布

转载最新推荐文章于 2024-08-12 15:56:33 发布 · 126 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/2474820/blog/519285

本文详细介绍了如何解决MySQL中出现的ERROR1820(HY000):'You must SET PASSWORD before executing this statement'的错误。只需执行一个简单的命令即可重置登录密码。

明明使用账户密码登录过后还是提示

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

这个错误

只需使用

mysql> SET PASSWORD = PASSWORD('123456');

这个语句重置一下登录密码即可

转载于:https://my.oschina.net/u/2474820/blog/519285

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

chilai2005

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

帅的数说

09-05

1164

刚安装好mysql5.7后，默认带有密码，但是不知道是什么。添加skip-grant-tables启动，进去改好密码后，重启。再次执行语句时报错：ERROR 1820 (HY000): You must SET PASSWORD before executing this statement 需要使用下面语句重新设置一次密码： SET PASSWORD = PASSWORD('123

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

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

01-02

606

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)

JACK111234的博客

12-29

177

You must reset your password using ALTER USER statement before executing this statement报错处理解决方式如下： MySQL版本5.7.6版本以前用户可以使用如下命令： mysql> SET PASSWORD = PASSWORD('root(密码)'); MySQL版本5.7.6版本开始的...

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

老徐的博客只有干货

05-27

6692

新安装好的mysql5.7数据库，用root登录以后执行操作报这个错。解决方法：mysql> alter user 'root'@'localhost' identified by 'root密码'Query OK, 0 rows affected (0.01 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec...

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

红豆的编程空间

05-16

249

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

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

乱写乱画

09-18

739

登录MySQL，输入SQL指令时出现错误： mysql> CREATE DATABASE port; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 解决：设置你的密码 set password="YOUR_PAS...

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

weixin_43520450的博客

07-20

3761

刚安装好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'

已解决 Mysql 8.0：ERROR 1820 (HY000): You must reset your password using ALTER USER statement ……的问题

Bye_Bai的博客

07-05

5204

解决 Mysql 8.0：ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.的问题。解决方法是要我们重新设置密码，然后就可以进行相关操作。

解决ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

july_2的专栏

12-12

9910

今天在MySql5.6操作时报错：You must SET PASSWORD before executing this statement解决方法，需要的朋友可以参考下 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement 非常诡异啊，明明用密码登陆进去了，怎么还提示需要密码。参考官

mysql ERROR 1820（HY000）问题的处理

最新发布

大新新大浩浩的博客

08-12

2554

mysql ERROR 1820（HY000）问题的处理

mysql 1820_mysql 报错ERROR 1820 (HY000):You must resetpassword

weixin_42144201的博客

01-18

7464

今天登录mysql(Server version: 5.7.11) 还是很好的，今天登录后执行任何命令都报下面的错误mysql> help contentsERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.mysql> h...

ERROR 1820 (HY000): You must reset your password

weixin_33738982的博客

08-10

1466

数据库安装后执行命令ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.解决办法：mysql> SET PASSWORD = PASSWORD('password123!');mysql> ALTER ...

mysql错误1820 you must reset your password using...

05-21

6839

mysql执行语句报错 mysql> use mysql; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 提示要用ALTER USER修改密码才可以但是如果想要设置非常简单的密码，比如123456会提示密码不符合要求 mysql> alter user 'root'@'localhost' ident...

mysql更改配置文件socket路径后登录报错：Can't connect to local MySQL server through socket '/var/lib/mysql.sock'

wudinaniya的博客

08-21

4996

mysql或pxc的配置文件 /etc/my.cnf 中若更改了socket路径 [mysqld] datadir=/mysql port=3306 socket=/mysql/mysql-node1.sock #socket不要指定，配了反而会出问题，让它自己去生成 /var/lib/mysql/mysql.sock ### 可以不指定pid-file路径，默认生成路径为 $datadir/...

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

小鸟下鸡蛋

08-31

2万+

mysql> alter user 'root'@'localhost' identified by '111111'; 输入以上语句，会提示： ERROR 1819 (HY000): Your password does not satisfy the current policy requirement. MySQL5.7 加强了安全保障，以上意思是密码不符合安全策略要

Foxmail登陆失败-NO LOGIN Login error password error