Reset a wiki user password

From Organic Design wiki
Revision as of 22:37, 21 November 2008 by Sven (talk | contribs)
Procedure.svg 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):

{{{1}}}

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> }}