Bug #180 GRANT/REVOKE is replicated even if --replicate-wild-ignore-table=mysql.%
Submitted: 21 Mar 2003 14:58 Modified: 8 Apr 2003 9:50
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:4.0 OS:Any (all)
Assigned to: Guilhem Bichot CPU Architecture:Any

[21 Mar 2003 14:58] Guilhem Bichot 
Description:
See synopsys.

How to repeat:
Start the slave with --replicate-wild-ignore-table=mysql.%, issue a GRANT
on the master and check that the mysql.% tables have been updated on the slave.

Suggested fix:
When executing a GRANT/REVOKE on the slave, check if inclusion/exclusion rules
match these tables user/host/db/table_privs/column_privs. 

The same thing applies to CREATE PROCEDURE (et al) in 5.0 and mysql.proc,
and maybe to UDF functions and mysql.func.
[8 Apr 2003 9:50] Guilhem Bichot 
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html

changeset 1.1428