if using mod_auth did you put the username etc in mysql.conf?
Gary
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 9:42 AM
Subject: Re: INTERNAL SERVER ERROR
> hi to all,
>
> i give in dblib.phtml (this is the connection info for mysql, i think)
> $host = "localhost"; // <----------------- db server
> $user = "root"; // <------------------ mysql username/password
> $pwd = "nobody";
> $db = "vsdadmsite"; // <----------------- db name
>
> root-password (nobody) i type in the mysql db..! (right?)
>
> in the siteuser table of vsdadmsite db i give
> id: testname
> passwd: testpasswd
>
> testname and testpasswd i type in the authenticate screen.
>
> what is wrong?
> thanks niko
>
>
>
>
>
>
> ----- Original Message -----
> From: "Gary Reid (cars-sold)" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, May 31, 2001 9:21 AM
> Subject: Re: INTERNAL SERVER ERROR
>
>
> > [Tue May 29 13:23:44 2001] [error] MySQL query failed: select
passwd
> > from siteusers where id='testname'
> >
> > this error is just telling you it cannot get the data from the table to
> > match your query
> >
> > [Tue May 29 13:23:44 2001] [error] MySQL failure reason: Access
denied
> > for user: '@localhost' to database 'vsdadmsite'
> >
> > this error is telling you why - and the error is saying that anaonymous
> user
> > (nothing before localhost) cannot access this database - so check to
make
> > sure you have added root (or whoever) as the database username in either
> the
> > script or the mysql.conf or whatever you are using for the database
> > connection string - and make sure you have added a password for root in
> > mysql set up. As default mysql allows anonymous access but with no
> > privileges
> >
> > Gary
> >
> >
>
