First, do not replicate the MySQL database from the master to the 
slave(s). Then create users on the slave that only have the desired 
rights. In your case, SELECT only.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 3/16/04, 2:02:13 PM, cvarda <[EMAIL PROTECTED]> wrote regarding Blocking 
INSERT/UPDATE on SLAVE (replication):


> Hi there.

> How could I deny users or applications issuing INSERT or UPDATEs queries 
on
> my SLAVE server? This is intended to ensure that slave will not have data
> which MASTER don't know.

> Thanks...

> []s,
> Conrado



> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to