Solution to MySQL server login error ERROR 1820 (HY000)

Fault site: Log in to the MySQL server and get this error no matter what command you execute

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

How could this happen? Am I on a fake server?

Cause analysis: This is mainly controlled by a parameter default_password_lifetime, see the official explanation

Look carefully, the Note information is sometimes more useful than the above information (I usually ignore the English notes, but it is possible that the part you ignore may also help performance)

Problem solving: In the open source world, we are not afraid of errors, because only when errors are reported can we have solutions. Let's take a look at your environment.

mysql> select version();
+--------------+
| version() |
+--------------+
| 5.7.10-3-log |
+--------------+
1 row in set (0.01 sec)
 
mysql> show variables like 'default_password_lifetime';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| default_password_lifetime | 360 |
+---------------------------+-------+
1 row in set (0.00 sec)

I see. Then change the password.

alter user user() identified by "123456";

The problem was successfully solved! The current user can successfully execute commands within the scope of his permissions.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.