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

在linux服务器上安装了mysql之后，首次执行sql时，会强制要求更改默认的初始密码：“ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.”。

详细提示信息如下：

[root@iZuf6ho556ymkgz5z68m95Z mysql]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.17

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

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> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> 
mysql> 

这是mysql自身的安全机制，可以不用在意，直接修改一下密码即可。

alter user 'root'@'localhost' identified by 'test..';

mysql

看完文章，有任何疑问，请加入群聊一起交流！！！

扫码关注本站微信公众号，第一时间获取网站更新动态！

本文地址：https://www.jiweichengzhu.com/article/3ac3e7ee62cd495fac4189ee1ffbf226

关于转载：若站内作品和文章得到了你的青睐，欢迎各位朋友分享到个人站长或者朋友圈，但转载请注明文章出处和原文链接！

很赞哦！ ()