Error Message

[Lovebev1]

Does anyone know what these error messages are about?

Warning: mysql_connect(): Access denied for user 'hoopstar_hoopsta'@'localhost' (using password: YES) in /home/hoopstar/public_html/vars.php on line 8

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/hoopstar/public_html/vars.php on line 10

Here is the code:

<?php
##Requires Edit##
$user = "created a user with all privleges";
$pass = "which password is this?";
$db = "hoopstar_HoopStartRegistration";

// open the connection
$connection = mysql_connect("localhost", "$user", "$pass");
// pick the database to use
mysql_select_db("$db",$connection);

[kasab]

Did you set up your user using

grant all on hoopstar_HoopStartRegistration.* to 'hoopstar_hoopsta'@'localhost' identified by 'a_password';

? In this, 'hoopstar_HoopStartRegistration' is the name of the database that MySQL is attempting to link to, 'hoopstar_hoopsta' is the user name and 'a_password' is the password.

If not, you would get the first warning message. Given that, there would then be no connection with the database, and you would recieve the second warning.

HTH

[bpat1434]

If you go into your mySQL control panel, you can add users w/ passwords, and then add them to databases. You need to create a user, and then add that user to the database with ALL priveleges.

Now, once you do that, take the username and password and plug them into your script. The username is the username you just created and the password is the password associated with that user.

The first error message tells you that you couldn't connect, and the second says that since you didn't connect, mySQL didn't return a valid resource link to a database (because you didn't connect). So the errors are not separate but related.

~Brett