Hey, I lost my admin password; oops.
And I tried searching for some answers but they are confusing and complicated. Anyone one got a simple way to reset or find the password. Thanks.
PS: "Lost Password Recovery Form" didn't work.
try to run this query in phpMyAdmin:
UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = 'X'
Change the X to your User ID, your password will be test.
run this in your phpmyadmin and replace x with your userid, password will be test.
UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = 'X'
(2010-01-27, 03:28 AM)ccalby Wrote: [ -> ]try to run this query in phpMyAdmin:
UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = 'X'
Change the X to your User ID, your password will be test.
Hey guys thanks for the posts but where do it put it and whats "you have to choose at least one column to display."
maybe this image will help explain
http://img204.imageshack.us/img204/6356/stuffff.gif
PS: sorry I'm such a pain
Click on the sql tab and put in that query and press go.
(2010-01-27, 03:40 AM)ndm250 Wrote: [ -> ] (2010-01-27, 03:28 AM)ccalby Wrote: [ -> ]try to run this query in phpMyAdmin:
UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = 'X'
Change the X to your User ID, your password will be test.
Hey guys thanks for the posts but where do it put it and whats "you have to choose at least one column to display."
maybe this image will help explain
http://img204.imageshack.us/img204/6356/stuffff.gif
PS: sorry I'm such a pain
No probs, we are here to help
click the SQL tab (2 to the left) and run that code.
If you still need help, please post it
(2010-01-27, 03:42 AM)JonP Wrote: [ -> ]Click on the sql tab and put in that query and press go.
Hey guys thanks again, but this time I get "Affected rows: 0 (Query took 0.0002 sec)" so I don't think it worked and I even replaced the X with admin. What should I do now?
http://img213.imageshack.us/img213/2569/...gggggg.jpg
No your uid isn't your username, your uid is at the end of the URL when you view your profile.
For example, if you're the first one who signed up, your user id would be 1.
Thanks everyone it worked!