List:Replication« Previous MessageNext Message »
From:a.smith Date:September 29 2010 9:21am
Subject:Re: Access Denied to replication slave for Update statements
View as plain text  
Quoting aaron beverly <aaron.beverly@stripped>:

> 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.



Thread
Access Denied to replication slave for Update statementsaaron beverly29 Sep
  • Re: Access Denied to replication slave for Update statementsa.smith29 Sep
    • Re: Access Denied to replication slave for Update statementsaaron beverly29 Sep
      • Re: Access Denied to replication slave for Update statementsa.smith29 Sep
        • Re: Access Denied to replication slave for Update statementsAaron Beverly29 Sep
Re: Access Denied to replication slave for Update statementsJesper Wisborg Krogh29 Sep