Content added Content deleted
imported>mutante m (Reverted edits by 65.44.66.100 (Talk); changed back to last version by mutante) |
imported>SaraLee mNo edit summary |
||
| Line 7: | Line 7: | ||
Where obviously "somepass" is changed the password you want to set and "whatever" is changed to the user name as it is listed in the table "user". |
Where obviously "somepass" is changed the password you want to set and "whatever" is changed to the user name as it is listed in the table "user". |
||
from [http://meta.wikimedia.org/wiki/MediaWiki_FAQ#How_do_I_change_a_user.27s_password.3F] |
from [http://meta.wikimedia.org/wiki/MediaWiki_FAQ#How_do_I_change_a_user.27s_password.3F] [http://www.premiumdissertations.com/ dissertation writing] |
||
[[Category:Wiki]] |
[[Category:Wiki]] |
||
Revision as of 08:30, 25 August 2010
How do I change a user's password?
Assuming that $wgPasswordSalt is set to true (the default), you can use the following SQL query:
UPDATE user SET user_password = MD5(CONCAT(user_id, '-', MD5('somepass'))) WHERE user_name = 'whatever';
Where obviously "somepass" is changed the password you want to set and "whatever" is changed to the user name as it is listed in the table "user".
from [1] dissertation writing