MyBB Community Forums

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.

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.

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.

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ᴇЯ';

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

Thank you.
Regards
Paul.