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 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-only is set to 'ON' So as far as I can
> tell,
> it I should not be able to connect to the slave and insert rows into my
> tables. However, I AM able to insert rows into the tables.
>
> Have I missed some additional configuration option?
>
> I'm running 5.0.21 on Solaris...
>
> Thanks!
>
