MediaWiki/Password

Manually Reset Password

To reset password (will set to 'local'):

UPDATE user SET user_password=md5(concat(1,'-',md5('local'))) where user_id=1;

UPDATE `user` SET user_password = CONCAT(':B:1234:', MD5(CONCAT('1234-', MD5('somepass')))) WHERE user_name = 'someuser';

Note: MySQL salted (1234 is the salt. You can replace it with any number as long as both places the number is used are the same). Manually set the "B" format. This format is very easy to set from an SQL query. It is not the default format as it is weaker than pbkdf2, however that's ok as the user_password field will be upgraded to the correct format the next time the user logs in.