Hello,
I've locked myself out of admin.
How can I create a new user account with full admin permissions.
It's just the password I don't know.
Would I be able to reset that via phpMyAdmin?
Regards,
George.
What did you change, your primary usergroup?? If you did:
UPDATE `mybb_users` SET `usergroup` = '4' WHERE `uid` = '1';
Change the 1 if that's not your UID.
Hello,
I didn't change any groups.
I just setup the board and must of entered the wrong password as it was wrote down.
Anyway,
www.thediscussionzone.co.cc is the board. I just need admin access so I can reset the password. I haven't even logged into the board at all yet.
Regards,
George.
Oh, OK, well if you've just installed it'd probably have been quicker to install again but you can reset the password to test with this:
UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = '1';
Hello,
Worked. Thanks Matt.
Regards,
George.