[Mediawiki-l] sysop password forgotten

Thu Dec 8 15:13:49 UTC 2005

That wouldn't work because password hashes aren't a straight MD5 of
the password text. Google for "MediaWiki md5 password" for more.

Rob Church

On 08/12/05, Max de Mendizabal <max at upn.mx> wrote:
>
> Or you could try from the mysql prompt
>
> UPDATE user SET user_password=md5('mynewpassword') where
> user_name='WikiSysop' ;
>
> After you quit the mysql prompt delete the log created (because mysql will
> keep the unencrypted password there).
>
> Max
>
> On Thu, 8 Dec 2005, Hans Voss wrote:
>
> > Got it. I'll need to translate from dutch as I go along:
> > Procedure assumes:
> > *Linux with command prompt access
> > *access to php interpreter
> > *access to the wiki HTML source (LocalSettings.php file).
> > *mysql. Instead of direct mysql commandline access you could use
> > something like phpMyAdmin
> >
> > Settings like 'which database inside mysql is used' and 'what user and
> > password are required to access that database in mysql' can be found
> > by accessing the LocalSettings.php file in the wiki install.
> >
> > First you'll need access to the command prompt of the machine.
> > No root access required
> > start the mysql client: $ mysql -p -u wikiuser wikidb
> > Type the following query:
> >  SELECT user_id, user_name, user_password
> >  FROM user WHERE user_name = "WikiSysop";
> >
> > this should get you something like:
> > +---------+-----------+----------------------------------+
> > | user_id | user_name | user_password                    |
> > +---------+-----------+----------------------------------+
> > |       15 | WikiSysop     | e4bda1f6162596e744463e1d17c9cc0c |
> > +---------+-----------+----------------------------------+
> > (best viewed in non-proportional font type like Courier)
> >
> >> From the documentation I found how the password hash is created and I
> > wrote a small php program to do just that. (It's not user friendly but
> > it works).
> >
> > Create a file (for example mypwd.php) with approximately the following content:
> > <?php
> > # select user_id from user where user_name = "name of user";
> > $a=md5 ( "MyNewPa$$wordHere" );  # the new password you want
> > echo "\n\n";
> > # IN FRONT OF the minus sign ('-') enter the user_id found with the mysql query.
> > # (so replace the '5' with the id found).
> > echo md5 ( "5-{$a}"  );
> > echo "\n";
> > # call with php mypwd.php
> > ?>
> > The results the actual hash value that needs to be entered into the database.
> >
> > start mysql client again and enter the following query:
> > UPDATE user SET user_passwd = "new hash value" WHERE user_id = <userid-of-user>
> >
> > This should do the trick.
> > If this procedure is too much over your head, you might ask your
> > system admin to help you out.
> >
> >
> > Hope this helps.
> > On 12/8/05, Hans Voss <hans.voss at gmail.com> wrote:
> >> Yes there is. I have to look it up.
> >> It has to evolve some direct database hacking and php scripting.
> >> Procedure is for linux and you'll want access to the command prompt.
> >>
> >> I'll mail the solution once I found it.
> >>
> >> On 12/8/05, Markus Herrmann <HerrmanM at klilu.de> wrote:
> >>> hey guys,
> >>>
> >>> your are my last chance.
> >>>
> >>> the guy who has set up the wiki here in my foundation is gone.
> >>>
> >>> and now it's up to me the administrate the wiki. so i need the sysop
> >>> password. but i couldn't find it!
> >>>
> >>> is there any opportunity to recover the old password? or to change it?
> >>>
> >>> thx so far!
> >>>
> >>> ey i'm german! sry for my english ;-)
> >>>
> >>> greetz markus
> >>> _______________________________________________
> >>> MediaWiki-l mailing list
> >>> MediaWiki-l at Wikimedia.org
> >>> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
> >>>
> >>
> >>
> >> --
> >> ----
> >> Met vriendelijke groeten / With kind regards
> >> Hans Voss
> >> ---------------------------------------
> >> skype: hans.voss
> >> google talk enabled
> >> I am looking for people to invite to Gmail. I have 100 invitations left.
> >>
> >
> >
> > --
> > ----
> > Met vriendelijke groeten / With kind regards
> > Hans Voss
> > ---------------------------------------
> > skype: hans.voss
> > google talk enabled
> > I am looking for people to invite to Gmail. I have 100 invitations left.
> > _______________________________________________
> > MediaWiki-l mailing list
> > MediaWiki-l at Wikimedia.org
> > http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
> >
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>