Difference between revisions of "Reset a wiki user password"
From Organic Design wiki
(Formatting & additional info from SQL#Reset a password) |
m |
||
Line 7: | Line 7: | ||
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> | {{code|<mysql> | ||
− | + | SELECT user_id | |
+ | FROM prefix_user | ||
+ | WHERE user_name='WikiSysop'; | ||
</mysql> | </mysql> | ||
}} | }} | ||
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> | + | {{code|<mysql> |
UPDATE prefix_user | UPDATE prefix_user | ||
SET user_password=md5(CONCAT('1-',md5('newpassword'))) | SET user_password=md5(CONCAT('1-',md5('newpassword'))) |
Revision as of 22:42, 21 November 2008
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):
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.