Re: [PHP-DB] db connect probs

2003-01-15 Thread Doug Thompson
MySQL cannot find the username in its grant tables.

The error message very clearly states that there is no user named
'x,@host' which is the value of your $user variable.  For your example,
$email == 'x' and $femail == '@host'.  The comma is included because it
is part of the literal string, i.e., inside the double quotes.

hth,
Doug

On Tue, 14 Jan 2003 22:08:11 -0600, Addison Ellis wrote:

hello,
   do you have any idea why the following(line 106)would return 
the following
error message ?  the login.php has an included form to create an 
account and that is what will not connect.

$connection = mysql_connect($host, $user,$password) //this is line 106

Warning: Access denied for user: 'x,@host' (Using password: YES) in 
/users/infoserv/web/register/login.php on line 106

Warning: MySQL Connection Failed: Access denied for user: 'x,@host' 
(Using password: YES) in /users/infoserv/web/register/login.php on 
line 106
Couldn't connect to server.

my required file is as follows:
?
  $user=$email,$femail;
  $host=$hostname;
  $password=password('$password'),password('$fpassword');
  $database=$classes;
?


thank you again for your time. addison
-- 
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
[EMAIL PROTECTED]
[EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] db connect probs

2003-01-14 Thread Larry E. Ullman
	do you have any idea why the following(line 106)would return the 
following
error message ?  the login.php has an included form to create an 
account and that is what will not connect.

$connection = mysql_connect($host, $user,$password) //this is line 106

Warning: Access denied for user: 'x,@host' (Using password: YES) in 
/users/infoserv/web/register/login.php on line 106

Warning: MySQL Connection Failed: Access denied for user: 'x,@host' 
(Using password: YES) in /users/infoserv/web/register/login.php on 
line 106
Couldn't connect to server.

You can take this one at face value: that combination of username, 
password, and host does not have permission from MySQL to access the 
database. First, verify what information is being used to connect. 
Then, if you can, confirm these values by logging into MySQL another 
way (e.g., through the mysql client). If you just added these 
permissions, be sure to reload the permissions before logging in.

Larry


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php