MySQL 5.1.14 and later.
Data modification statements made to tables in the
mysql database are replicated according to
the value of binlog_format;
if this value is MIXED, then these
statement are replicated using the row-based format. However,
statements that would normally update this information
indirectly — such GRANT,
REVOKE, and statements
manipulating triggers, stored routines, and views — are
replicated to slaves using statement-based replication.
MySQL 5.1.13 and earlier.
User privileges are replicated only if the
mysql database is replicated. That is, the
GRANT,
REVOKE,
SET PASSWORD,
CREATE USER, and
DROP USER statements take
effect on the slave only if the replication setup includes the
mysql database.

User Comments
Add your own comment.