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!
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
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.
(2015-02-18, 04:50 PM).m. Wrote: [ -> ]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?
after the database upload through
phpMyAdmin, usually we get a message like below
Quote: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
are you using a free web host .. that could be a reason for the broken database upload
(2015-02-18, 05:54 PM).m. Wrote: [ -> ]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.
(2015-02-18, 05:54 PM).m. Wrote: [ -> ]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.
^ yes, sql file parts can be uploaded in sequence
(2015-02-18, 06:10 PM).m. Wrote: [ -> ]^ 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