MySQL Help

graphicart · August 29th, 2004, 8:49 PM

Hi guys, searched a little but couldn't find any direct answers, I am new to SQL and I am trying to set up a vBulletin Board, I have created the DB and user, added these to the config.php script but I get this error, what am I doing wrong?

Quote:

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/*******/public_html/forums/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.

here is the script, of course stars replaced the actual names

Quote:

$servername = '********.com:3306';

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

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

**AlexH** · August 29th, 2004, 8:58 PM

Did you add the user to that database? To do it if you haven't already, just go into cPanel then the MySQL Databases and find at the end of the list of databases two drop down menus, select the user you're useing and the database, then click Add User to Db.

Also, for the $servername, you only need localhost.

graphicart · August 29th, 2004, 9:17 PM

Yes, I should have added that, the user was added and the Access Host is localhost, But I got that error, so know I am puzzled, does the upload folder have to be in the public_HTML directory or the root or where?
thanyou for your quick reply, much appreciated,
Did you mean in the script or on the MySQL page

Quote:

$servername = '********.com:3306';

Quote:

$servername = 'localhost:3306';

**Bigjohn** · August 29th, 2004, 9:28 PM

Quote:

Originally Posted by graphicart

Yes, I should have added that, the user was added and the Access Host is localhost, But I got that error, so know I am puzzled, does the upload folder have to be in the public_HTML directory or the root or where?
thanyou for your quick reply, much appreciated,
Did you mean in the script or on the MySQL page

should not be a PORT- ditch the :3036

graphicart · August 29th, 2004, 9:55 PM

Did that but still get this:

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/*******/public_html/forums/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.

Also the script staes this:
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.

**AlexH** · August 29th, 2004, 11:34 PM

Use 'localhost' (without the quotes)

graphicart · August 30th, 2004, 12:08 PM

just wanted to thank you all for the help, although I'm guessing there must be some delay after you set up a MySQL Bd before you can access it because I tried one more time with the original settings I had and it worked

August 29th, 2004, 8:58 PM	#2 (permalink)
AlexH Peaches! Excelling Contributor Joined in Jul 2003 Lives in Ottawa, Ontario, Canada Hosted on Jose, Pass19 564 posts Gave thanks: 0 Thanked 0 times	Did you add the user to that database? To do it if you haven't already, just go into cPanel then the MySQL Databases and find at the end of the list of databases two drop down menus, select the user you're useing and the database, then click Add User to Db. Also, for the $servername, you only need localhost. __________________ alex.honeywell [ seigousei.net - pass19, binuweb.com - jose ]

August 29th, 2004, 11:34 PM	#6 (permalink)
AlexH Peaches! Excelling Contributor Joined in Jul 2003 Lives in Ottawa, Ontario, Canada Hosted on Jose, Pass19 564 posts Gave thanks: 0 Thanked 0 times	Use 'localhost' (without the quotes) __________________ alex.honeywell [ seigousei.net - pass19, binuweb.com - jose ]

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

August 29th, 2004, 9:55 PM	#5 (permalink)
graphicart Registered User Fresh Surpasser Joined in Aug 2004 5 posts Gave thanks: 0 Thanked 0 times	Did that but still get this: Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/*******/public_html/forums/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. Also the script staes this: 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.

August 30th, 2004, 12:08 PM	#7 (permalink)
graphicart Registered User Fresh Surpasser Joined in Aug 2004 5 posts Gave thanks: 0 Thanked 0 times	just wanted to thank you all for the help, although I'm guessing there must be some delay after you set up a MySQL Bd before you can access it because I tried one more time with the original settings I had and it worked

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)