If you forgot your MediaWiki password, you’ll want to reset it.  If you can, go to the login page and have the password sent to you, this is of course the easiest thing to do.

Sometimes though, you’re a stupid Sys Admin (read me) and you set up a wiki real quick and think “I won’t forget the password!”. You then decide not to include your email address when creating the wiki account profile. So if you’re that Sys Admin (read me) here are the instructions for retrieving that password:

1. log on to mysql
2. type the following query:
   

   UPDATE user SET user_password = MD5(CONCAT(user_id, ‘-’, MD5(’newpassword‘))) WHERE user_id = uid

3. go back to the MediaWiki page and log in.

And next time don’t think you can remember a password, you can barely remember your name.