While on MySQL 4.0.24, I connect to my database: $ mysql -u amavisd -ppassword spamassassin
This user can select and insert (that is confirmed) but cannot delete a row: mysql> delete from users where 'fullname' = 'bongo.net' limit 1; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'spamassassin' That exact SQL statement was successfully used by root as a test. Here is info using root user connected to mysql database: mysql> select host,db,user,select_priv,insert_priv,update_priv,delete_priv from db; +-----------+--------------+---------+-------------+-------------+-------------+-------------+ | host | db | user | select_priv | insert_priv | update_priv | delete_priv | +-----------+--------------+---------+-------------+-------------+-------------+-------------+ | localhost | spamassassin | amavisd | Y | Y | Y | Y | | 127.0.0.1 | spamassassin | amavisd | Y | Y | Y | Y | +-----------+--------------+---------+-------------+-------------+-------------+-------------+ What is going on? -- Peter __________________________________________________________ Find your next car at http://autos.yahoo.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]