Manual talk:Resetting passwords

user_password field

In which file is the user_password field?

WikiSysop

The only reason to manually reset the password is when you don't have sysop privileges to reset user passwords.

Here's the SQL for MySQL and for MediaWiki version 1.13 and later. It is done in one statement and only requires putting the password in one location.

UPDATE USER
SET user_password = CONCAT(SUBSTRING(user_password, 1, 3),
                           SUBSTRING(MD5(user_name), 1, 8),
                           ':',
                           MD5(CONCAT(SUBSTRING(MD5(user_name), 1, 8),
                                      '-', MD5('new password'))))
WHERE user_name = 'WikiSysop';