Backup restore SQL error

[psneep]

Hi all.

my domain is TFFGO DOT COM " (TFF) stands for The Football Factory" so go to my web address if you want to see the error for yourself.

I had a really great soccer community website 2 years ago running MyBB platform, i have 4 different lots of back ups for .GZ files and .sql db files, but i keep getting this error below after doing 4 restores, i did terminate the whole website after every restore from my WHM cPanel.

SQL Error:1045 - Access denied for user 'thefootb_forum'@'localhost' (using password: YES)
Query:[READ] Unable to connect to MySQL server

the site used to run with MyBB 1.6 but i just can't get it to run from my backups.

Could someone please help me with this issue, I don't know much about MyBB sql so any help is much appreciated.

Thank you.
Regards
Paul.

[effone]

This is not related to MyBB. You are not being able to connect to your database.
Check your database username / password / dbhost or contact your hosting provider.

[psneep]

Hi effone.

OK thank you for your reply.

---

ok can someone tell me how i can change my password in phpmyadmin please.

I have gone into phpmyadmin>SQL>then pasted:
UPDATE mybb_users SET password = MD5('my password here'), salt = '' WHERE uid = 'SᴩiDᴇЯ'; then clicked Go and it changed nothing.
this is the result showing below:

0 rows affected. (Query took 0.0002 seconds.)

then pasted this:
UPDATE mybb_users SET password = '098f6bcd4621d373cade4e832627b4f6', salt = '' WHERE uid = 'SᴩiDᴇЯ'; also nothing changed, this is the result showing below:

0 rows affected. (Query took 0.0002 seconds.)

Is there something i am not doing right, because now i have to do an upgrade so i can get into my site, but i need my password changed.

this is the new error now:

MyBB has experienced an internal error and cannot continue.

Error Type:
MyBB Error (42)
Error Message:
Your board has not yet been upgraded. Please do so before attempting to browse it.

Thank you.
Regards
Paul.

[.m.]

below Query can be helpful in changing your password (assuming that table prefix is mybb_)

UPDATE mybb_users SET password = 'newPassword', salt = '' WHERE username = 'SᴩiDᴇЯ';

[psneep]

Thank you all and especially M your query worked and fixed the password issue thank you.

Thank you.
Regards
Paul.