Hui wrote:
>
> Hi,
>
> We have apache 1.3.19, PHP4.0.2 and mysql installed in
> our redhat linux 6.2 system. For some reasons, we got
> error message " denied for user: nobody@localhost
> (Password :YES)". Database in my local machine.
>
> Code: mysql_pconnect("$localhost","$username",
> "$password") or die ("couldnt connect database");
>
> mysql, php and apache all are located in directory
> /usr/local/.
>
> I dont know why we got the "nobody@localhost"? In
> httpd.conf of apache, group and user is nobody, do you
> think we need to change them, if so, what we should
> do? by the way, mysql was installed by standard way.
>
> This is errors caused by mysql or php configuration or
> apache configuration? or mysql database user set up?
>
> thanks,
> Hui
>
You need to setup a mysql user for apache with the desired permissions
( see GRANT in the manual ).
You need to make your connect scripts in your CGI use this user.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php