[Mediawiki-l] sysop password forgotten

[Arthur Guy]

You forgot the closing brackets!

UPDATE user SET 
user_password=md5(concat(user_id,'-',md5('mynewpassword'))) where 
user_name ='WikiSysop' ;

-Arthur

-----Original Message-----
From: mediawiki-l-bounces at Wikimedia.org
[mailto:mediawiki-l-bounces at Wikimedia.org] On Behalf Of Vinayak Nagaraj
Sent: 08 December 2005 16:53
To: MediaWiki announcements and site admin list
Subject: Re: [Mediawiki-l] sysop password forgotten

The correct specification would be

UPDATE user SET 
user_password=md5(concat(user_id,'-',md5('mynewpassword') where 
user_name ='WikiSysop' ;




Vinayak





Max de Mendizabal 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

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