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