Re: cannot delete row but permissions ok

--- 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 'f

Re: cannot delete row but permissions ok

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' = 'bo

Re: cannot delete row but permissions ok

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 PRO

cannot delete row but permissions ok

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 dat