MyBB Community Forums

Hey there, I'm Thomas!

I have a problem, my problem is that I have a forum using MyBB 1.6 on a a hosting site and I want to transfer it to another hosting site. I've already transferred the files but I have a problem with the database.

This is the error I get:

SQL query:

--
-- Database: `fees0_7204177_NewForum`
--
CREATE DATABASE IF NOT EXISTS  `fees0_7204177_NewForum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


MySQL said: Documentation

#1044 - Access denied for user 'a7159641_forum'@'localhost' to database 'fees0_7204177_NewForum' 

As you can probably guess the hosting company that I am transferring from is 0fees and the hosting company I am moving to is 000webhost.

The name of the database on 0fees was NewForum and the name of the database is forum.

All help is much appreciated!

Thanks.

Did you go into config.php of your myBB installation and change the database connection settings? Make sure that you use the same prefix that the original MyBB installation used as well, if you transfer the database by importing it.

Thanks! Could you point me in the direction of the config.php file?

config.php file is located in ./inc folder of MyBB files server.

Thanks!
I'm just making sure I've gotten this right.

$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'a7159641_forum';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] = 'server41.000webhost.com';
$config['database']['username'] = 'a7159641_forum';
$config['database']['password'] = '******';

That's what it is at the moment but now I'm getting this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1130 - Host '31.170.160.105' is not allowed to connect to this MySQL server
Query:
[READ] Unable to connect to MySQL server

^ see this reply

Thanks, that's all sorted.

I have this problem again now when I upload the database, haha.

--
-- Database: `fees0_7204177_NewForum`
--
CREATE DATABASE IF NOT EXISTS  `fees0_7204177_NewForum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


MySQL said: Documentation

#1044 - Access denied for user 'a7159641_thom'@'localhost' to database 'fees0_7204177_NewForum'

Would it be because they're both different database names?

--EDIT---

Fixed, thanks everyone! ;D!