reset password query?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Registered User
Posts: 215
Joined: Sun Aug 10, 2003 2:17 am

reset password query?

Post by AndrewThomas »

is there a query i can run in phpmy admin to reset my admin password?
i was very drunk the other day when i reset my password and i forgot it and i do not have any other admin logins at the time..

if no one know how to do this then could someone tell me the query i run that i can make another user admin?


Cause EVERYONE Listens To Techno
Former Team Member
Posts: 9877
Joined: Wed Jun 29, 2005 5:55 am
Location: Somewhere in the Midwest...

Post by cybrid23 »

Passwords are md5 hashed..So that may not work.

Try this:

Admin Toolkit

The options in the right drop down may help.

Or, you can make a new user. Go into phpmyadmin, find the user in the users table, and change the user_level from '0' to '1'
---Never leave home without a towel and your peril sensitive sunglasses.
---Do Not PM Me For Support. It will go unanswered.

Return to “2.0.x Support Forum”