Peter Abplanalp SUPER privilege required for simple update
May 09, 2015; 02:05
Peter Abplanalp
SUPER privilege required for simple update
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 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.
thanks,
-peter
May 09
Johnny Withers Re: SUPER privilege required for simple update
May 09, 2015; 08:44
Johnny Withers
Re: SUPER privilege required for simple update
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!