From: Date: September 29 2010 10:03am Subject: Re: Access Denied to replication slave for Update statements List-Archive: http://lists.mysql.com/replication/1977 Message-Id: <201009292003510000@936321046> MIME-Version: 1.0 Content-Type: text/plain; charset=none Content-Transfer-Encoding: 8bit Does the statement happen to involve a stored function, trigger, or view that is used with the definers privileges? If so the error might come from there. Jesper ------- Original Message ------- From: a.smith@stripped To: aaron beverly Sent: 29/9/10, 19:21:01 Subject: Re: Access Denied to replication slave for Update statements Quoting aaron beverly : > No, the error is on the slave. I am getting that error message by > running "show slave status". Queries on the master execute without > error. It is just the replication that is getting hung up. > > I am actually following the howto that you recommended. That is where > I got the info to set up replication. And everything works, except for > this issue. > So it wont be slave user privileges either, this is used to read from the master, not write to the slave. Have you tried updating the table on the slave using the command that is failing when connected locally to the DB on the slave? Worth checking the server isnt in read only mode, or that there arent file system permissions problems. Andy. -- MySQL Replication Mailing List For list archives: http://lists.mysql.com/replication To unsubscribe: http://lists.mysql.com/replication?unsub=jesper@stripped