Your password has expired. To log in you must change it using a client that supports expired passwor

gary-liu發表於2017-03-07
原文網址 : https://blog.csdn.net/revitalizing/article/details/60800986
client

密碼過期，需要重設密碼，處理過程如下。

mysql> use mysql
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> set password = password('123456789');
Query OK, 0 rows affected, 1 warning (0.03 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)

mysql> exit
Bye

重置密碼後重新登入即可。

相關文章