Difference between revisions of "Reset a wiki user password"
From Organic Design wiki
(New page: {{procedure |description = Use this pr...) |
(alternatively, go to Special:Userlist and get the id from there) |
||
| Line 5: | Line 5: | ||
}} | }} | ||
| − | You need to log in to the database directly. Then obtain the user's id as in the following example: | + | 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): |
<pre> | <pre> | ||
SELECT user_id FROM prefix_user WHERE user_name='user'; | SELECT user_id FROM prefix_user WHERE user_name='user'; | ||
Revision as of 20:25, 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):
SELECT user_id FROM prefix_user WHERE user_name='user';
Then and apply the query shown in the following example to set the password for that user id (here the user id is 2222):
UPDATE prefix_user SET user_password=md5(CONCAT('2222-',md5('newpassword'))) WHERE user_id=2222;
