Re: MySQL vs user www-data -- AHA!

[w trillich <will@pinncomp.net>]

apparently i wasn't connecting via localhost--it was using the
/etc/hosts name of the computer ('server' in this case) instead!

> mysql -u www-data -p will
Enter password:
ERROR 1044: Access denied for user: '@localhost' to database 'will'
> mysql -u www-data@localhost -p will
Enter password:
ERROR 1044: Access denied for user: '@localhost' to database 'will'
> mysql -u will -p will
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 314 to server version: 3.22.32-log

Type 'help' for help.

mysql> grant all privileges on *.* to 'www-data'@server ;
mysql> Bye
> mysql -u www-data -p will
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 315 to server version: 3.22.32-log

Type 'help' for help.

mysql> \u mysql
Database changed
mysql>

so it was falling back on host 'localhost' with generic username
(blank) instead of generic host with username 'www-data' (just as
it says in section 6.1 of the manual).

even better, the 'missing' "Apache->log" method error is gone, too! 
	[Mon May  8 23:56:37 2000] [error] 
	[Mon May  8 23:56:37 2000] null: Can't locate object method "log" via 
	package "Apache" at /usr/local/lib/site_perl/Stonehenge/DBILog.pm 
	line 95.

all fixed! thanx, Christian, for all your calm pointers...  !!

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Their is five errers in this sentance.