--source include/master-slave.inc create database db1; --connection slave stop slave; change replication filter REPLICATE_IGNORE_DB = (mysql); start slave; --connection master use test; create user replicated1; --sync_slave_with_master select user, host from mysql.user; stop slave; change replication filter REPLICATE_DO_TABLE = (db1.foo); start slave; --connection master use test; create user not_replicated; use db1; create user also_not_replicated; select user, host from mysql.user; --sync_slave_with_master select user, host from mysql.user; --connection master drop database db1; drop user 'replicated1'@'%'; drop user 'not_replicated'@'%'; drop user 'also_not_replicated'@'%'; --sync_slave_with_master stop slave;