Peter wrote:
--- Dan Trainor <[EMAIL PROTECTED]> wrote:
Peter wrote:
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
Hi -
Have you ran a 'flush privileges' as root after granting the amavisd
user permissions to do those actions?
Thank you. That did it. You know I was looking for a related button on
phpMyAdmin but it does not exist (from what I can see) so I figured it did
this in the background.
Hi -
You know, I don't recall exactly what PHPMA calls it, I rarely use
PHPMA. However, I believe it's something along the lines of "reload".
Glad to hear it helped.
Thanks
-dant
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]