Reset a wiki user password

From Organic Design wiki
Revision as of 22:41, 21 November 2008 by Sven (talk | contribs) (Formatting & additional info from SQL#Reset a password)
Procedure.svg Reset a wiki user password
Organic Design procedure

You need to log in to the database directly. First obtain the user's id as in the following example (alternatively, go to Special:Userlist and get the id from there):

{{{1}}}

Then apply the query shown in the following example to set the password for that user id (here the WikiSysop user id is 1): Note that the password is a nested concatenation of both the md5 of the user_id combined with the md5 password. {code|<mysql> UPDATE prefix_user SET user_password=md5(CONCAT('1-',md5('newpassword'))) WHERE user_id=1; </mysql> }}


See also