Reseting Admin Password

[alfrocks]

I recently got in a pickle, while messing around with my gallery I realized that I didn't know either my password nor e-mail address for my user. So, I went and messed around and I managed to change the e-mail address for my user somehow. I pressed the "forgot password" link and put in my new address so it could reset my password, I got the notification e-mail asking if I really wanted to reset the password, I cliked it and nothing happened I didn't receive a new e-mail address with a new password. Now when I try and log-in back to my administrator user the pre-filled password doesn't work anymore. That means I don't have access to manage my gallery anymore.

So is there a way I can fix this little problem? Is there some "backdoor" entrance so I enter the gallery or anything like that?

Thank you.
http://alfrocksmedia.com/albums/

[Nibbler]

Set a new password on your admin account using phpmyadmin. It will be user_id 1 in the prefix_users table. Set the password as an MD5 hash using the dropdown box. Search the board for detailed instructions.

[alfrocks]

Thank you very much the problem is now fixed Sorry I didn't search the message board before posting this message. This all was very complicated to do. I never did figure out how to work the md5 hash ordeal but after ready different posts I just created a new user and copied the password to my admin account.

[ashelby]

To eliminate anyone else that may be confused, can this only reside in the CPG Database?

I have my CPG bridged with PHPbb2 and although I know I was putting password in correct, I went ahead and followed what I found on the forums to fix it.  The MD5 hash reset via mySQL database manager.

I only found one username and password in there and it is not the one I am using as Admin, in fact I don't see the username anywhere but in the DB.  I am up to about a 15 minute wait on the password reset, because I have guessed wrong so many times now.

We will see about 2220 seconds.   

Aric

[ashelby]

I don't know why, but it worked! 

Now, why the heck was I even disabling it???  Something with groups. 

Aric