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@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)