HI
from the command line run
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON database_name.*
TO [EMAIL PROTECTED]
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:[EMAIL PROTECTED]
Sent: 20 August 2003 18:53
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
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: '[EMAIL PROTECTED]' (Using password: YES) in
/var/www/html/dbid/mysql/database.php on line 17
Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in /var/www/html/dbid/mysql/database.php on line 17
Could not connect: Access denied for user: '[EMAIL PROTECTED]' (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
[EMAIL PROTECTED]
(925) 866-2790
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
