Javability (Java, Zaurus, Linux, Live)
by Jean-Marc Autexier, Saarland/Germany
cat /dev/www | egrep 'Java|Linux|Zaurus|ITnews|Live' > blog
16.4.07
06:50 Mediawiki: reset user password (
,
,
,
)
I forgot my mediawiki password again, so I document here how to reset it.
login to mysql database
UPDATE wikiuser SET user_password = md5(CONCAT('your_user_id-',md5('new_password'))) WHERE user_id=your_user_id;
Remark: your_user_id is the id of your user in wikiuser table. First a md5 digest of the new_password is build, then the user_id and "-" are added before it, and the whole is md5 again.