[thelist] RE: apache/mysql errors....

Peter Lovatt pjln1 at sunmaia.net
Wed Aug 20 20:29:06 CDT 2003


HI

from the command line run

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
           ON database_name.*
           TO apache at localhost
           IDENTIFIED BY 'password';


(you may want to give more restrictive privileges)

that should fix it - you don't have privileges set for the user apache

Peter

-----Original Message-----
From: bruce [mailto:bedouglas at earthlink.net]
Sent: 20 August 2003 18:53
To: mysql at lists.mysql.com; users at httpd.apache.org;
thelist at lists.evolt.org
Subject: apache/mysql errors....


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 at localhost' (Using password: YES) in
/var/www/html/dbid/mysql/database.php on line 17

Warning: MySQL Connection Failed: Access denied for user: 'apache at localhost'
(Using password: YES) in /var/www/html/dbid/mysql/database.php on line 17
Could not connect: Access denied for user: 'apache at localhost' (Using
password: YES)
---------------------------------

I have added the mysql user/password to the php file. I can access mysql
using the user/password from the linux command line.

However, when I check mysql, I don't have an Apache user defined in the user
table. Do I need to have one defined, or should the php app utilize the
user/passwd/dbname that I provide in the db_connect function?

I can access the phpMyAdmin application with no apparent issues/problems...

A check of google indicates that the issue seems to be related to not having
mysql setup for an Apache user....

As an additional question, if I have a web app that has a mysql db, do I
need to allow Apache to have access to each table that the app uses...?????

Any help/assitance/pointers to resolve this would be greatle appreciated...

Regards,

Bruce
bedouglas at earthlink.net
(925) 866-2790




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=peter@sunmaia.net




More information about the thelist mailing list