reset a mediawiki password with mysql

i run a idea-journal kind of mediawiki. i’ve enabled a few friends of mine to access this wiki.

one of my users was being (unusually) idiotic and forgot his password. and he couldn’t use the forgot password functionality because i never configured email. and, i still don’t want to configure email.

so, i had to manually change his password using the mysql command line. here’s the sql update statement. run it and ask your user to log in and change his password to something more sensible. execute this statement as your mysql root user:

update user set user_password = md5(concat(user_id,’-',md5(’new_password’))) where user_name=someone

i should have fixed this out a while ago, but i had been procrastinating.