Hi Peter,
There is a password being suppled - see code (btw, its local testing only,
hence the root user)
//Database Settings
$db_host = 'localhost'; //database hostname
$db_name = 'powerpla_powerplay'; //database name
$db_user = 'root'; //database USER name
$db_pass = 'rootpass'; // database password
function db_connect()
{
if ($dbc = @mysql_connect($db_host,
$db_user, $db_pass)) {
if
(!mysql_select_db($db_name)) {
die('<p>Could not connect to the database because: <b>' . mysql_error() .
'</b></p>');
}
} else {
die('<p>Could not connect to the database because: <b>' . mysql_error() .
'</b></p>');
}
}
-----Original Message-----
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Thursday, 27 January 2005 12:27 AM
To: Christian Biggins; mysql@lists.mysql.com
Subject: RE: Access denied for user - I cant work this out
hi
you are not passing a password to mysql - check your code to see if this is
correct.
Peter
> -----Original Message-----
> From: Christian Biggins [mailto:[EMAIL PROTECTED]
> Sent: 26 January 2005 12:27
> To: mysql@lists.mysql.com
> Subject: Access denied for user - I cant work this out
>
>
> Hi All,
>
> I am consistently getting;
>
> Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
>
> I am connecting through php with the same script I use all the time, I
> have checked it and dbl checked it for problems.
>
> I can connect to mysql in a prompt and I have added new users with all
> priv's and connected with them - obviously its more a server issue
> than mysql (I think)...
>
> MySQL version is 4.0.21
> PHP Version 4.3.8
> On a Win2k server using apache 2 (just a local testing server).
>
> Any info would be muchly appreciated.
>
> Christian
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
