--- 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.
__________________________________________________________
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]
