RE: [Mediawiki-l] sysop password forgotten

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

> 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

> wrote a small php program to do just that. (It's not user friendly

> 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 &lt;hans.voss(a)gmail.com&gt; 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 &lt;HerrmanM(a)klilu.de&gt; 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

>>> password. but i couldn't find it! >>> >>> is there any opportunity to recover the old password? or to change

>>> >>> thx so far! >>> >>> ey i'm german! sry for my english ;-) >>> >>> greetz markus >>> _______________________________________________ >>> MediaWiki-l mailing list >>> MediaWiki-l(a)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

_______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l