一、起源:
今天一上班就听到说error-log里记录了大量的
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
二、mysql 用户密码过期的处理:
1、从一条简单的create user 看mysql密码过期的内在逻辑
mysql> create user exuser@'%' identified by 'exPass@352';
Query OK,0 rows affected (0.01sec)
mysql> show create user exuser@'%';+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| CREATE USER for exuser@% |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| CREATE USER 'exuser'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*CD0895