Moving hosts

[Mellymonster]

Hey guys,

My forum is moving to a new host, or well trying too, and we are encountering DB errors... We have backed up the DB closed the forum down, and put it into the new host, we then did the Config.php file, and changed the DNS, then comes the db errors, it takes about 15 minutes, and then db errors started coming.

The errors are like this

Database error in vBulletin :

Cannot use database newsite_christgarden

MySQL Error : Access denied for user 'newsite_christ'@'localhost' to database 'newsite_christgarden'
Error Number : 1044
Request Date : Tuesday, June 2nd 2009 @ 03:32:22 PM
Error Date : Tuesday, June 2nd 2009 @ 03:32:22 PM
Script : http://www.christsgarden.com/
Referrer :
IP Address : (took the ip addy off)
Username :
Classname : vB_Database
MySQL Version :

Does this mean that the $config['MasterServer']['servername'] = is wrong?

We had it with another servername, and I was getting this error

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'newsite_christ'@'pass88.dizinc.com' (using password: YES)
/home/newsite/public_html/christsgarden.com/forums/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Tuesday, June 2nd 2009 @ 03:23:20 PM
Error Date : Tuesday, June 2nd 2009 @ 03:23:20 PM
Script : http://christsgarden.com/
Referrer :
IP Address : (took the IP out)
Username :
Classname : vB_Database
MySQL Version :

Help if you can? Please???

[EagleNick]

Something in the config.php file isn't set properly. Re-check your DB name, username and password.

Then ensure that the username attached to the database you're using has full DBA permissions.

[Mellymonster]

Ok I did see I missed an s in my sites name in the config, and I fixed that, but now I'm getting this again

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'newsite_christ'@'pass88.dizinc.com' (using password: YES)
/home/newsite/public_html/christsgarden.com/forums/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Tuesday, June 2nd 2009 @ 04:51:34 PM
Error Date : Tuesday, June 2nd 2009 @ 04:51:34 PM
Script : http://christsgarden.com/
Referrer : http://christsgarden.com/
IP Address : (took IP out)
Username :
Classname : vB_Database
MySQL Version :

is the pass88 the problem? prolly hard to tell without being in the cpanel to get it all, huh? But in cpanel it says that the servername is pass88... Could it be something in the database itself?

[Outbackmark]

There is still something not correct in the DB username and password in the config.php.
You need to check the db username and password in the Domain CP, some servers automatically add "user_" to the front of the username/DB Name entered when the DB is created. This must be in the config.php file.
You will find this under MySQL Data Bases, then scroll down to users, remember you must add the user to the database after creating the user as well, or it will not work either.
* user = CP login name, so in your case it may look something like christga_pass88

[Mellymonster]

Everything but 1 problem right now, members are still seeing the offline message but there is another thread on this :)