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(a)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(a)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(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 left.
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)Wikimedia.org