密码过期怎么办。

jikcheng

遇到密码过期。还有怎么预防密码过期。

1、查看当前用户是否密码过期
mysql> select mysql> select Host,User,Password,password_exp;
+-----------+------+-------------------------------------------+------------------+
| Host      | User | Password                                  | password_expired |
+-----------+------+-------------------------------------------+------------------+
| localhost | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | N                |
| mysqldb   | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | N                |
| 127.0.0.1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | N                |
| ::1       | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | N                |
| localhost | jik  | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | Y                |
+-----------+------+-------------------------------------------+------------------+
5 rows in set (0.00 sec)

2、过期后会报什么错误。
mysql> use test
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
3、怎么解决。
set password = password('new_passwd');