Regaining access to forum, please help..

[Lynne]

If you cannot register a new account and have absolutely no access to any other accounts, the final option is a database query.

MAKE A FULL DATABASE BACKUP BEFORE YOU MANUALLY EDIT THE DATABASE. VERIFY IT AS WELL.

Open the database in a tool like phpmyadmin.

Run the Query:

UPDATE user AS user
set password = MD5(concat(MD5('pass1234'), user.salt))
WHERE userid = 1

The above will reset the password of user with userid = 1 to pass1234. Change the userid if your Admin account is not userid 1.

*NOTE* - If you have a table prefix setup in your config.php file then you must put the table prefix in front of the first "user" on the first line.

Example:

UPDATE vb_user AS user
set password = MD5(concat(MD5('pass1234'), user.salt))
WHERE userid = 1

The above query is if vb_ is the table prefix.

You should be able to tell easily if there is a prefix if all the table names start with the same few characters.

Once the query is run the password will now be pass1234 or whatever you set.

(The above is NOT valid for 5.1.10 and up.)