Randall Loffelmacher wrote:
Is there a way to retrieve/reset a forgotten password
for the WikiSysop
user? Or is the only alternative to do a complete re-install of the
Wiki? If a re-install is required, can someone provide an URL with some
details about how to do this?
WikiSysop is not special; it's just like any other user account as
regards passwords. There's a 'mail me a new password' button on the
login page.
If you didn't set your e-mail address, you can go in the database and
set it manually:
UPDATE user
SET user_email='myaddress(a)example.com'
WHERE user_name='My username' LIMIT 1;
If e-mail doesn't work on your server, you'll have to manually generate
a new password and stick it in the database. The stored password hash is
the MD5 hash of the concatenation of the user_id number, a hyphen ('-'),
and the MD5 hash of the plaintext password. Something like this should
do it:
UPDATE user
SET user_password=MD5(concat(user_id,'-',MD5('new password')))
WHERE user_name='My username' LIMIT 1;
-- brion vibber (brion @
pobox.com)