Lost admin password

[THVossen]

How can I reset it? On vb 5.2.4

Email config isn't setup and can't find any sql queries!

[Paul M]

What do you mean by "Email config isn't setup" ?

[THVossen]

I didn't set up email configuration correctly so I can't reset the password via email

--------------- Added [DATE]1476659679[/DATE] at [TIME]1476659679[/TIME] ---------------

Nevermind. Solved it.

I just made a new account, added it to superadmins and then changed password from Admin CP there

[Lynne]

You could also run a query on the database.

Run the Query:

UPDATE user AS user 
SET token = concat(MD5(concat(MD5('pass1234'), user.token)),' ', user.token), scheme = 'legacy' 
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 token = concat(MD5(concat(MD5('pass1234'), user.token)),' ', user.token), scheme = 'legacy' 
WHERE userid = 1;

The above query is if vb_ is the table prefix.