Dear sir,
recently i changed host. and i have upload my forum form old backup in a new host.
Now i cant login my admin, also cant upgrade mybb..
I have tried this process:
Quote:UPDATE mybb_users SET salt = '', password = '098f6bcd4621d373cade4e832627b4f6' WHERE uid = '1';
doesnt work!!!
is there any soluation ???
Try this. Create a "dummy" account, go to your hosts cPannel, then phpmyadmin. Run this script.
UPDATE mybb_users SET usergroup='4' WHERE uid='1'
Change the "WHERE uid='1'" to your dummy account, so if your dummy account is user id 7, change the 1 to 7.
What this does is moves user id 1 to the usergroup with the id of 4 (administrators by default)
Then just change your mains accounts password, or just stick with that account you just promoted.
Hope this helped.
EDIT- May have read this wrong, is it your websites admin? or is it the hosts cPannel? sorry if I read this wrong.
Entering the query you posted above will change your password to "test". Did you try logging in with your username and test which is the password?
After you migrated your host, did you make a new mysql user? Did you also edit your config.php and setting.php and replace the data with your new mysql user info? Oh yeah did you also make a new database and replace your old DB with the new DB in config.php file?
Thanks mate!! problem solved..