[Mediawiki-l] sysop password

[Titoxd@Wikimedia]

There are instructions how to do this in the MediaWiki FAQ:

http://www.mediawiki.org/wiki/Manual:FAQ#How_do_I_reset_a_password.3F

Titoxd.

-----Original Message-----
From: Klaus Becker [mailto:colonius at free.fr] 
Sent: Tuesday, May 08, 2007 12:50 PM
To: MediaWiki announcements and site admin list
Subject: Re: [Mediawiki-l] sysop password

Am Dienstag, 8. Mai 2007 16:38 schrieb Klaus Becker:
> Hi folks,
>
> I cannot connect as sysop. While installing my wikisite, I created an
> account WikiSysop (porposed by mediawiki) with a password I wrote down on
a
> paper, so I am sure of it. But later on, wiki tells me the password is
> wrong.
>
> I deleted LocalSettings.php, I installed the site again and I indicated
the
> same password. That changed nothing. When I try to connect as sysop and I
> ask to send me a new password, wiki tells me that sysop has no email
> account.
>
> I tried with firefox and galeon.
>
> So what can I do ?
>
> cheers
>
> Klaus

There really seems to be a problem with Sysop password. I tried a brand new 
installation of Mediawiki 1.9.3 on my computer, and I cannot connect as 
WikiSysop ! While searching on the web I see I am not the only one who has 
this problem.

The solution I found is :

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

found several times, for example at 
http://troll.chemi.muni.cz/whitezone/development/charon/wiki/index.php/Help:
Contents

how do I find the user_id for WikiSysop ? How to execute this command on 
Linux ? I suppose it is a mysql-command ?

Klaus