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