修改我的关键字但仍无法登录

时间:2015-02-23 作者:user1142618

不幸的是,我丢失了wordpress密码,所以我用mysql命令更新了它。

    UPDATE wp_users SET user_pass = MD5(\'hello\') WHERE id=1;

    mysql> select * from wp_users;
+----+----------------------------------+----------------------------------+---------------+---------------------+----------+---------------------+------------------------------------+-------------+--------------+
| ID | user_login                       | user_pass                        | user_nicename | user_email          | user_url | user_registered     | user_activation_key                | user_status | display_name |
+----+----------------------------------+----------------------------------+---------------+---------------------+----------+---------------------+------------------------------------+-------------+--------------+
|  1 | 5d41402abc4b2a76b9719d911017c592 | 5d41402abc4b2a76b9719d911017c592 | luofeiyu      | [email protected] |          | 2015-02-16 13:24:31 | $P$BdoVxdl8z6/8fhBmumk0vuMdlDsARz. |           0 | luofeiyu     |
+----+----------------------------------+----------------------------------+---------------+---------------------+----------+---------------------+------------------------------------+-------------+--------------+
1 row in set (0.00 sec)
现在,为什么我不能在我的wordpress中使用用户名“罗飞宇”和密码“你好”登录?

1 个回复
最合适的回答,由SO网友:xsonic 整理而成

你不知怎么变了user_login 到您的密码哈希。

user_login 应该是luofeiyu

结束