Suck on Step 2!

[allstar89]

here's the problem:

Step 2) Connect to the database

Attempting to attach to database

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/fhlinux200/d/drumforum.co.uk/user/htdocs/forum/includes/db_mysql.php on line 140

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.

Would be a help if you could be so kind as to reply!

Thanks

Adam

[Zachery]

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.


As the error says. You need to confirm your config.php values and ensure that they are indeed correct.

[allstar89]

i can't find what i have done wrong...

Can someone do a bit of matching for me?

if so..

This is my hosts instructions for mysql database....

Username: drumforum
Password: XXXXXXXXX
Hostname: Mysql4.streamline.net
Database Name: drumforum

Here is VB's form....

// ****** DATABASE SERVER NAME ******
// This is the hostname or IP address of the database server.
// It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
// If you are unsure of what to put here, leave it at the default value.
$servername = 'Mysql4.streamline.net';

// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusername = 'drumforum.co.uk';
$dbpassword = 'XXXXXXX';

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'drumforum';


Its saying something is wrong... But what??

[Steve Machol]

This error means either:

1. One or more of the following is wrong in your config.php file:

$servername (except in rare cases, this should almost always be left as 'localhost' or '127.0.0.1')
$dbusername
$dbpassword
$dbname

If you are unsure of what the appropriate values are then you will need to ask your web host.

2. Or that this db user is not assigned to that database or does not have permission to access MySQL to create or access a database. You may need to first manually create the database and assign the db user to it. Since each web host is different, if you do not know how to do this then contact your web host for help.

3. Or you are running MySQL 4.1.x. As of MySQL 4.1.X there is a new password hashing system. PHP4 does not have builtin support for it as of yet, however PHP5 does. In order for your old PHP4 MySQL clients to be able to connect to the MySQL 4.1.X database you need to set an OLD_PASSWORD. You should be able to run the following Query to make it possible for PHP4 to access the MySQL 4.1.X database.

SET PASSWORD FOR 'username'@'localhost' = OLD_PASSWORD('password');

More info is here:

http://dev.mysql.com/doc/mysql/en/password-hashing.html

http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html