Content added Content deleted
imported>SaraLee mNo edit summary |
imported>Kghbln |
||
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] |
||
[[Category:Wiki]] |
[[Category:Wiki]] |
Revision as of 17:06, 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]