[Mediawiki-l] sysop password forgotten

[Max de Mendizabal]

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
>