Re: SUPER privilege required for simple update

2015-05-09 Thread Johnny Withers
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" wrote: > hello, > > I have a replication client where replication stopped because mysql said > that the SUPER privilege was required for an u

Re: Why does a group_concat on a join change aggregate values?

2015-05-09 Thread hsv
On 2015/05/07 19:42, Paul Halliday wrote: Should have showed the whole thing. Take a look here (click image to see full output): http://www.pintumbler.org/tmp I don't see why this worries you. Joining often increases variation. Indeed, if in some case an inner join never did, maybe the joined

SUPER privilege required for simple update

2015-05-09 Thread Peter Abplanalp
hello, 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 ne