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're replicating all databases, but don't want statements
that affect user privileges to be replicated, set up the slave
to not replicate the mysql
database, using
the
--replicate-wild-ignore-table=mysql.%
option. The slave recognizes that issuing privilege-related SQL
statements have no effect, and thus it does not execute those
statements.
User Comments
Add your own comment.