MyBB Community Forums

Full Version: Confusion with configuration file when moving to a new host
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello! I've recently been attempting to move my forum ( http://muaraegamma.x10host.com/forum/index.php, hosted by the free host https://x10hosting.com/ ) to a new host and domain ( http://mu-arae-gamma.com/ hosted by https://www.ehost.com/ ) using this guide: https://docs.mybb.com/1.8/faq/moving-to-a-new-web-host/

However when going to change the database configuration variables, I'm not sure exactly what I'm supposed to put there? I imported my data correctly as far as I can tell, uploaded all the files correctly using filezilla, but I don't know what information I'm supposed to change or what I'm supposed to change it to in the config.php file.

muaraega_database is the SLQ database on the new host, muaraega_admin is the myslq user



$config['database']['type'] = 'x';
$config['database']['database'] = 'x';
$config['database']['table_prefix'] = 'x';

$config['database']['hostname'] = 'x';
$config['database']['username'] = 'x';
$config['database']['password'] = 'x';

are the fields in the config file, but I've changed them around so much I no longer have any clue what goes where, so I'm throwing in the towel and asking for help.


I currently have it set as

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

$config['database']['hostname'] = 'localhost';
$config['database']['username'] = 'muaraega_admin';
$config['database']['password'] = '******';

and
[Image: ITmwCyq.png]
This is the error I'm currently receiving.
is the database name correct at the new web host server ?
$config['database']['database'] = 'muaraega_database';
[Image: dppTCQQ.png]

I believe so, and all the information imported there is correct/matches what it was on the old host.
You could just delete any user assigned to that database and then recreate them. Perhaps a fresh user might work properly.
Deleted user, made a new one called "muaraega_test" and changed it in the config file, same error.
^ can you also check at the server details whether localhost correct for the database server ..
I found this page while looking to confirm that localhost was correct. Seems that it is. The "muaraega_" section that it adds automatically when registering an SLQ database/username seems to be the "cpanelUsername" it's asking for in the database name/username.

Everything I was looking at seemed to suggest it was a problem with the configuration variables, but now I'm almost certain they're correct and don't have a clue what's causing the problem.


Just for something to try, I input the settings as if the automatically added "muaraega_" was still required in addition to using it for the "cpanelUsername."
[Image: eQGmt5s.png]
This is the error I got for that.
No idea if that helps or means anything, sorry, I'm running out of ideas on things to try and baffled as to what the problem even is.
when you created new user for the database, have you added database privileges to that user ?

if direct help required, you may PM me temporary access to web host panel. you can change your credentials later.
Thank you again to .m. , everything is working the way it should be now.
I'd suggest to run file verification tool from below location and replace any missing files from MyBB 1.8.10 pack

admin panel >> tools & maintenance >> file verification

ignore reported images & ignore files reported from install folder & its sub-folders