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!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]