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!
>
Are you logging in as root on the slave when you try to insert rows?
read-only is ignored for users with root or replication privileges.
