I am trying to set up replication to a single slave to ensure that it
is working correctly. I have everything set up, and replication
starts normally, but I am getting the following error whenever an
Update statement is executed:
Error 'Access denied; you need the SUPER privilege for this operation'
on query. Default database: 'ehungry'. Query: 'UPDATE customer_order
SET created_at='2010-09-29 00:33:23'...(truncated for brevity)
Now, my understanding is that I only need the Replication Slave
privilege to run replication, but just to be certain, I granted all
privileges to my replication user, and the error persists.
I have searched for an explanation, but I can find no similar issue
discussed regarding this kid of error on an Update query.
I am running MySQL version 5.0.27 on RHEL. The tables in question are
InnoDB tables. Other kinds of queries work correctly, including, oddly
enough, Insert statements. And not all Update statements generate this
error. I am not 100% certain yet, but I believe this is occurring
only when the tables affected are InnoDB tables.
Any help is greatly appreciated.
Aaron L Beverly