MediaWiki

It happens everyone, you cannot remind a password of some account. Especially with Administration accounts this happens. And that administration account is just that one that you really need!

Well, that’s what i had with an MediaWiki installation. The Sysop account was lost, no e-mail address filled in so no recovery possible. Luckily i found the solution and I’m going to share it with you.

 

UPDATE user SET
user_password=md5(concat(user_id,’-',md5(‘YourPassword‘))) where
user_name =’Username‘ ;

This little MySQL code is all you need. The password in MySQL is hashed with MD5 and that again is hashed with your userid.
Do not forget to change the password and the username you want to reset. Also if you are using a prefix for the tables make that change.

That’s all, hope it will help you, it did for me