If you've forgotten it and email isn't working
What do I type in phpmyadmin
Well. You will have to reset all the forum database.
Or get a back-up from the last back-up you had.
No you won't... you can run this query:
UPDATE `mybb_users` SET `password` = '098f6bcd4621d373cade4e832627b4f6', `salt` = '' WHERE `uid` = 'X';
Change the X to your UID, your password will then be test.
your sure that's right? It didn't work...
Then you didn't run it right. You did run it on your users table and change your UID, yeah??
Well, I pasted what you posted into the "SQL query on database" part but i really don't have much clue what i'm doing
There isn't much to it, in phpMyAdmin, once you've chosen your database from the list on the left, click the SQL tab along the top, paste the code in, change the X to your UID, and press Go.