+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Installation and Upgrades Support (https://community.mybb.com/forum-182.html)
+--- Thread: Database error when installing (/thread-219132.html)
Database error when installing - richardhammond - 2018-08-05
Hey, I use 000webhost and I created a database on it, copied and pasted the exact info but it says cannot connect.
It has worked before!
RE: Database error when installing - Serpius - 2018-08-06
(2018-08-05, 10:15 PM)richardhammond Wrote: Hey, I use 000webhost and I created a database on it, copied and pasted the exact info but it says cannot connect.
It has worked before!
Ahem...
You are not being very clear in this post.
Did you install the MyBB software to create a new forum website?
Exactly... what did you do? Give more details.
RE: Database error when installing - Wires - 2018-08-06
Also please post the actual error you’re receiving.
RE: Database error when installing - richardhammond - 2018-08-06
The error I am reciving is 'Cannot connect to database localhost with username and password entered" or whatever.
I am trying to create a new forum and install it. It has worked before but not now. I am copying the sql database straight from 000webhost.
RE: Database error when installing - Serpius - 2018-08-06
(2018-08-06, 12:50 AM)richardhammond Wrote: The error I am reciving is 'Cannot connect to database localhost with username and password entered" or whatever.
I am trying to create a new forum and install it. It has worked before but not now. I am copying the sql database straight from 000webhost.
Why don't you install MyBB first... then... overwrite the database with your saved database?
Make sure that when you do a new installation of MyBB, the prefix of the database MUST match your saved database. Or else, it will not work.
That seems to be the logical thing to do.
RE: Database error when installing - richardhammond - 2018-08-06
How do i find the prefix of the database? It says nowhere in phpmyadmin or the databases page and I am not able to continue unless i have sucefully added the database.
RE: Database error when installing - Johnny98 - 2018-08-06
(2018-08-05, 10:15 PM)richardhammond Wrote: Hey, I use 000webhost and I created a database on it, copied and pasted the exact info but it says cannot connect.
It has worked before!
Hi man, i'm not sure your problem is the same as mine but maybe it is.
I had my forum on 000webhost too and when i moved it to a paid host i had all kinds of errors, after trying all i found out this was my prob:
when i was trying to save my database, not all tables were saved. Sometimes just 19 went to the backup, sometimes 25 and i think mybb has 77. So i solved it like this, i selected the database tables in groups of 4 and that way got all the 77 and put it in the new database on the new paid webhost. Maybe it is because at the time i was trying to do it 000webhost servers were too busy and unstable? Anyway, check that you have all the database tables, that's how i did it
RE: Database error when installing - richardhammond - 2018-08-06
thanks
RE: Database error when installing - Serpius - 2018-08-06
(2018-08-06, 06:21 AM)Johnny98 Wrote:(2018-08-05, 10:15 PM)richardhammond Wrote: Hey, I use 000webhost and I created a database on it, copied and pasted the exact info but it says cannot connect.
It has worked before!
Hi man, i'm not sure your problem is the same as mine but maybe it is.
I had my forum on 000webhost too and when i moved it to a paid host i had all kinds of errors, after trying all i found out this was my prob:
when i was trying to save my database, not all tables were saved. Sometimes just 19 went to the backup, sometimes 25 and i think mybb has 77. So i solved it like this, i selected the database tables in groups of 4 and that way got all the 77 and put it in the new database on the new paid webhost. Maybe it is because at the time i was trying to do it 000webhost servers were too busy and unstable? Anyway, check that you have all the database tables, that's how i did it
That's one of the biggest reasons why I truly detest free hosting sites.
Free hosting websites are very limited and most of the time do not offer customer support.