重庆思庄Oracle、Redhat认证学习论坛

标题: 密码过期怎么办。 [打印本页]

---

作者: jikcheng    时间: 2014-11-8 15:46
标题: 密码过期怎么办。
遇到密码过期。还有怎么预防密码过期。

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');

---

欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)

Powered by Discuz! X3.2