WackoWiki

View source for Re: How to reset password of Admin account?

This can happen, especially if you work on a local testing stack like XAMPP without outbound e-mail configured. When this first happened to me, I was quite puzzled.

HOTFIX:

Create a new account, then go in phpMyAdmin or similar to the ##user## table and the ##usergroup## table.
Add the ##user_id## of your new account and the ##group_id## of the Admins group in a new record in the ##usergroup_member## table.

user table
#|
*| user_id | user_name | ... | email_confirm |*
|| 4 | AccountName | ... | 5674baa2364e9d79... ||
|#

usergroup table
#|
*| group_id | group_name | ... |*
|| 1 | Admins | ... ||
|#

usergroup_member table
#|
*| group_id | user_id |*
|| 1 | 4 ||
|#
The values may differ in your case.

Now login with the new account and you should now as member of the Admins group be able to login into the Admin panel.

Regarding your e-mail, please check if you confirmed your e-mail, you see this in the ##email_confirm## field in the user table - which should be empty.
If you can login into the Admin panel, you can send you an test e-mail in the e-mail module.

More about the debug options tomorrow.