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.

Reset user_newpassword
In the SQL commands it is much better to set the user_newpassword field instead of the user_password field. The user_newpassword field will prompt you to change the password. If a troll is trying to find out how to hack into a Wiki, this will keep the same password. It is only slightly more secure than the other way, but every little bit helps. --Randyrls (talk) 12:03, 17 March 2012 (UTC)