Go to: CPanel > Database Management > phpmyadmin > Click on "SQL" tab > and enter the following query and Press "Go"
UPDATE mybb_users SET password = '098f6bcd4621d373cade4e832627b4f6', salt = '' WHERE uid = '1';
Login with test as the password.
(2011-01-16, 04:56 AM)bigoliver Wrote: [ -> ]Hi,
I'm sorted,
I changed the No: 1 at the end of the code to 2 then 3 until it told me lines have changed, rather than saying 0 lines changed as in the pic.
I then checked users on my site and all 3 where now admin, 1 being my test account woowooh. The other 2 are my girl friend and mate from work. so no problems there.
thank you all kindly for your help,
This is a great forum with some great member and a world of knowledge
Oliver
P.S. It seems I deleted myself not just blocked myself, guess that's why my password wasn't working
Deleting account has been known to bring up error: password incorrect messages.
lol, glad its sorted
Cheers once again to you all for your time
That was pretty stupid, Were you testing it?