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.
If you are replicating all databases, but do not want statements
that affect user privileges to be replicated, set up the slave
not to replicate the mysql database, using
the
--replicate-wild-ignore-table=mysql.%
option. The slave recognizes that privilege-related SQL
statements have no effect, and thus it does not execute those
statements.
See Section 16.4.1.16, “Replication of the mysql System Database”, for more
information.

User Comments
Add your own comment.