Cant Upload VB at a New Server>>

[Khalid-B]

Hello,

I just changed my hosting and trying to run VB at new server but cant .
I have uploaded all files in FTP and also changed config.php with my corect data but getting error .
Here is error that i am getting at step 2,


Step 2) Connect to the database

Attempting to attach to database

Error description: mysql_connect() [function.mysql-connect]: Access denied for user 'xyz'@'localhost' (using password: NO) /home/xyz/public_html/forum/includes/class_core.php on line 274

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.

dont understand even entered my corect data in configphph file

Need help please.......
Thanks

[calorie]

If you think you have everything set correctly in the vB config.php file, shoot your host an email to confirm the values and database access.

[Khalid-B]

first of all thanks for your reply.

yes i asked them they told every thing ok from there end , and i am sure i have entered my correct data in config.php.

please help guys .

[calorie]

If everything is correct from their end, then it seems there is an incorrect entry in the config file. Nobody can tell you what to place in the config file except perhaps your host, so double check with them that you have the correct values.

[Dismounted]

Judging from the error, you don't seem to have anything written in for your MySQL password.

[Khalid-B]

yes i entered .
DB name
DB username,
DB user password ,
i entered correctly but getting same error evevn i made another DB account and tried but same error .
Please guys help i am still stuck at same point.
Really dont understand.
Please helppppp
Thanks

[Dismounted]

Well it seems you haven't. Re-download the vBulletin package and replace your config.php with a fresh one, then edit it as necessary.

[Khalid-B]

i redownloaded it and than entered my new data in config.php but not working . same error.

thanks

[Dismounted]

You're still entering it wrong, are you sure you've entered between the quotes and not overwritten the array key name?

[Khalid-B]

yes i am sure i entered correct data in config.php.
Thanks

[dyna88]

Is a prefix added to your Data base name and user name and if so are you adding it in your config file???

eg... prefix_databasename prefix_databaseusername

[Khalid-B]

here it is ....


// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config['Database']['DB_Name'] = 'forum';

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$config['Database']['myemail@xyz.com'] = 'dbmaster@example.com';

// ****** FORCE EMPTY SQL MODE ******
// New versions of MySQL (4.1+) have introduced some behaviors that are
// incompatible with vBulletin. Setting this value to "true" disables those
// behaviors. You only need to modify this value if vBulletin recommends it.
$config['Database']['force_sql_mode'] = false;



// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;

// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config['MasterServer']['DB_username'] = 'root';
$config['MasterServer']['DB password'] = '';

[toolmanwill]

you must have a password then if it not letting you connect, in your config you have no password, unless its easyphp i'm sure you have a password for mysql

[Khalid-B]

guys , help please........................

[Dismounted]

I knew it. You're overwriting the array key name. You're doing this:
$config['MasterServer']['DB password'] = '';
You need to do this instead:
$config['MasterServer']['password'] = 'DB Password';
This needs to be corrected for every option. I suggest you get a fresh config.php and enter your details correctly.

[dyna88]

He also did it with the username.............

$config['MasterServer']['DB_username'] = 'root';

should be

$config['MasterServer']['username'] = 'DB_username';

[Dismounted]

I know, I pointed that out if you didn't read the end of my post :).

[dyna88]

It just registered.... I am a little slow in the morning...LOL