Difference between revisions of "Reset a wiki user password"

From Organic Design wiki
m (→‎See also)
(Change source-code blocks to standard format)
Line 8: Line 8:
  
 
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):
 
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):
−
{{code|<mysql>
+
<source lang="mysql">
 
SELECT user_id FROM prefix_user WHERE user_name='WikiSysop';
 
SELECT user_id FROM prefix_user WHERE user_name='WikiSysop';
−
</mysql>
+
</source>
−
}}
 
 
Then apply the query shown in the following example to set the password for that user id (here the '''WikiSysop''' user id is 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.
 
Note that the password is a nested concatenation of both the md5 of the user_id combined with the md5 password.
−
{{code|<mysql>
+
<source lang="mysql">
 
UPDATE prefix_user SET user_password=md5(CONCAT('1-',md5('newpassword'))) WHERE user_id=1;
 
UPDATE prefix_user SET user_password=md5(CONCAT('1-',md5('newpassword'))) WHERE user_id=1;
−
</mysql>
+
</source>
−
}}
 
  
  

Revision as of 18:11, 22 May 2015

Procedure.svg Reset a wiki user password
Organic Design procedure

Before reading further consider the password reset extension which gives a simple form to reset wiki passwords.

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): 

SELECT user_id FROM prefix_user WHERE user_name='WikiSysop';

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. 

UPDATE prefix_user SET user_password=md5(CONCAT('1-',md5('newpassword'))) WHERE user_id=1;


See also

Retrieved from "https://organicdesign.nz/wiki/index.php?title=Reset_a_wiki_user_password&oldid=119848"