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.