Difference between revisions of "Reset a wiki user password"
From Organic Design wiki
(alternatively, go to Special:Userlist and get the id from there) |
|||
Line 6: | Line 6: | ||
You need to log in to the database directly. Then obtain the user's id as in the following example (alternatively, go to [[Special:Userlist]] and get the id from there): | You need to log in to the database directly. Then obtain the user's id as in the following example (alternatively, go to [[Special:Userlist]] and get the id from there): | ||
− | < | + | {{code|<mysql> |
SELECT user_id FROM prefix_user WHERE user_name='user'; | SELECT user_id FROM prefix_user WHERE user_name='user'; | ||
− | </ | + | </mysql> |
+ | }} | ||
Then and apply the query shown in the following example to set the password for that user id (here the user id is 2222): | Then and apply the query shown in the following example to set the password for that user id (here the user id is 2222): | ||
− | < | + | {code|<mysql> |
UPDATE prefix_user SET user_password=md5(CONCAT('2222-',md5('newpassword'))) WHERE user_id=2222; | UPDATE prefix_user SET user_password=md5(CONCAT('2222-',md5('newpassword'))) WHERE user_id=2222; | ||
− | </ | + | </mysql> |
+ | }} |
Revision as of 22:37, 21 November 2008
Reset a wiki user password Organic Design procedure |
You need to log in to the database directly. Then obtain the user's id as in the following example (alternatively, go to Special:Userlist and get the id from there):
Then and apply the query shown in the following example to set the password for that user id (here the user id is 2222): {code|<mysql>
UPDATE prefix_user SET user_password=md5(CONCAT('2222-',md5('newpassword'))) WHERE user_id=2222;
</mysql> }}