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

mysql初始化密码常见报错问题

1,然后执行 mysql -uroot -p ,输入上面的到的密码进入,用该密码登录后,必须马上修改新的密码,不然会报如下错误:

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


2,如果你想要设置一个简单的测试密码的话,比如设置为123456,会提示这个错误,报错的意思就是你的密码不符合要求

mysql> alter user 'root'@'localhost' identified by '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements



https://blog.csdn.net/memory6364/article/details/82426052

posted @ 2019-06-04 19:33  潇湘客2  阅读(2450)  评论(0编辑  收藏  举报