[thelist] apache/mysql errors....

[bruce]

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