Re: Trouble with read-only

Rod Heyd wrote: Hello, I'm trying to set up a replication slave as read-only, but the read-only part doesn't seem to be working. Replication between the master and the slave works fine. I have added the read-only keyword to the slave's my.cnf, and looking at the output of show variables indica

Re: Trouble with read-only

On 6/14/06, ravilr <[EMAIL PROTECTED]> wrote: Are you inserting rows as a root user? The root user will be able to write to tables even if read-only is set to 'ON'. Ah, yes. That was it. I forgot about that. Thanks. -Rod

Re: Trouble with read-only

Are you inserting rows as a root user? The root user will be able to write to tables even if read-only is set to 'ON'. --Ravi Rod Heyd wrote: Hello, I'm trying to set up a replication slave as read-only, but the read-only part doesn't seem to be working. Replication between the master and th

Trouble with read-only

Hello, I'm trying to set up a replication slave as read-only, but the read-only part doesn't seem to be working. Replication between the master and the slave works fine. I have added the read-only keyword to the slave's my.cnf, and looking at the output of show variables indicates that read-onl