Help - Access Denied - [READ] Unable to connect to MySQL server

[HeartSeeker]

This user has been denied support.

MyBB has experienced an internal SQL error and cannot continue.

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



SCREENSHOT: http://i.imgur.com/Fu72hmn.png

I looked up both names and everything seems fine. The password too.


If you can help I would appreciated so much.

Edit: My Database didnt upload fully! wtf!

[.m.]

please do not post multiple threads for the same issue.

you have to add user privileges for the database.
select the database in phpMyAdmin and click on privileges tab, select the user and add all privileges

[Sazze]

It's something in the config.php

Either the password, username or even host. Or the password of the database you created.

Edit: or try what .m. suggested above.

[HeartSeeker]

This user has been denied support.

please do not post multiple threads for the same issue.

you have to add user privileges for the database.
select the database in phpMyAdmin and click on privileges tab, select the user and add all privileges

Okay. I'm trying to find privileges in PhpMyAdmin since 10 minutes and I can't find it. Can you tell me where is it at?

---

Also I think my database hasnt been uploaded fully. There are tables missing like users?

When it finishes uploading it brings me to this: http://i.imgur.com/k5TfhiU.png
But I heard that when you finish uploading a database it should say '' Database uploaded sucessfully! ''
I didn't see that message.


SCREENSHOT of my tables:

1: http://i.imgur.com/k5TfhiU.png
2: http://i.imgur.com/uEjJ1vB.png

---

EDIT:

My database is 260MB. I zipped it to this format: bzip2 now it's 51.7MB

this way I can upload it. Here's a proof you can upload it as bzip2: File to Import:
File may be compressed (gzip, bzip2, zip) or uncompressed.
A compressed file's name must end in .[format].[compression]. Example: .sql.zip

_______________________________
So now I upload it, and I see in the mySQL database it's 128MB. but its supposed to be 260 MB?

Screenshot: http://i.imgur.com/TQcOMvo.png


I'm not sure if the database uploaded entirely?

[.m.]

after the database upload through phpMyAdmin, usually we get a message like below

import has been successfully finished, abcxyz queries executed.
(database file name)

in general, first table of MyBB database is adminlogs and last table is warningtypes

[HeartSeeker]

This user has been denied support.

Nope. It stops to : http://i.imgur.com/w1fxnuU.png

So that means the database wasnt uploaded successfully.

Me it didnt say upload sucessfully finished. It brings me to that page only : http://i.imgur.com/SwOdZ8h.png

[.m.]

are you using a free web host .. that could be a reason for the broken database upload

[HeartSeeker]

This user has been denied support.

are you using a free web host .. that could be a reason for the broken database upload

No I'm not. I'm using Cpanel that I paid for 15$ yesterday and I'm on a friend's server right now.

Here are the specs:

Operating System linux
Disk Space Usage

5.15 GB / ∞

Monthly Bandwidth Transfer
7.14 GB / ∞

I see that the IP is on Shared IP Address.

That's all I know.

---

are you using a free web host .. that could be a reason for the broken database upload

I'm using SQLdumbsplitter now. I'm splitting the 260MB to 6 parts.

Do you think MyPhpAdmin can accept 6 different files? One after another?
I'm uploading the first one splitted.

[.m.]

^ yes, sql file parts can be uploaded in sequence

[HeartSeeker]

This user has been denied support.

^ yes, sql file parts can be uploaded in sequence

Okay thanks. ^^ Does this needs to be checked also? ( Partial import checked or not? )

Screenshot: http://i.imgur.com/JjsDB5V.png