Re: SUPER privilege required for simple update
- Date: Sat, 9 May 2015 08:44:31 -0500
- From: Johnny Withers <johnny@xxxxxxxxxxxxx>
- Subject: Re: SUPER privilege required for simple update
It's there an update trigger defined on the table? It could be doing
something that requires the super privilege.
On May 9, 2015 3:12 AM, "Peter Abplanalp" <pabplanalp@xxxxxxxxxxxx> wrote:
> I have a replication client where replication stopped because mysql said
> that the SUPER privilege was required for an update statement. I tried
> running the same update under a normal user and it also failed saying the
> SUPER privilege was required. I thought the SUPER privilege was only
> necessary for admin tasks. Why is it being required for a simple table
> update statement?
> Interestingly, I am able to insert a new row into the table; however, i get
> the same error when i then try to update the new row. I have restarted
> mysql hoping that might fix the issue, no luck. i've also checked the file
> permissions on table files on the file system and they are all owned by the
> same user which is running mysql. I've tried to create another test table
> and was successful and could also insert and update that table with no
> issues. I am also able to insert and update other tables but I have not
> tried them all.
> I am at a loss. Any and all help appreciated.