httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon Drukman <...@cluttered.com>
Subject [users@httpd] Re: apache/mysql errors....
Date Thu, 21 Aug 2003 01:28:30 GMT
bruce wrote:
> Hi...
> 
> A mysql/Apache issue:
> 
> I get the following when I'm trying to run a test web site on an Apache
> 2.0/RH8.0 setup.
> 
> --------------------------------
> Warning: Access denied for user: 'apache@localhost' (Using password: YES) in
> /var/www/html/dbid/mysql/database.php on line 17
> 
> Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost'
> (Using password: YES) in /var/www/html/dbid/mysql/database.php on line 17
> Could not connect: Access denied for user: 'apache@localhost' (Using
> password: YES)
> ---------------------------------
> 

log in to your mysql server as root or some other sufficiently 
privileged account and execute:

grant select on *.* to apache@localhost identified by 'yourpasswordhere';

this will let apache select from any table in any database.  if you want 
to grant additional permissions or restrict anything then you should 
read the mysql manual for details of the GRANT command.

you don't need to restart or anything.  the user/pw combo should be 
instantly available.

-jsd-



---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message