Hello,
I'm using a simple master-server replication setup for all the
databases. It is great, but sometimes someone tries to insert
something into the slave database by mistake. I would like to prevent
this, but I also mirror the mysql database (so if something happens
with the master, I just restart the mysqld to act as a master and I
change the roles). So I need to keep the original permissions intact.
Is there some way (e.g. command-line flag or mysql command), to forbid
all the writes to everyone except the replication thread?
Thanks,
Juraj.
--
-----------------------------------------------------------------------
|Juraj Bednar | Homepage at http://juraj.bednar.sk/ |
|computer journalist | Store at http://www.geekstore.sk/ |
|system administrator | PGP key: http://juraj.bednar.sk/ |
|independent consultant | Please stand for your freedom! |
|Please don't send me mail using proprietary file formats |
-----------------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
