Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.3.13
-
CentOS Linux release 7.8.2003 (Core)
-
Not for Release Notes
Description
Hi,
We already set the options below in our .cnf file
[mariadb]
|
binlog-ignore-db=mysql
|
binlog-ignore-db=information_schema
|
binlog-ignore-db=performance_schema
|
replicate_ignore_db=mysql
|
replicate_ignore_db=information_schema
|
replicate_ignore_db=performance_schema
|
but it keeps writing create user in the bin log, thus the user keeps being replicated in the slave.
CREATE USER `cehau37_Copy1`@`193.1.1.2`
|
/*!*/;
|
# at 486
|
#200818 22:49:56 server id 101 end_log_pos 528 CRC32 0xe766ab23 GTID 0-101-78 ddl
|
/*!100001 SET @@session.gtid_seq_no=78*//*!*/;
|
# at 528
|
#200818 22:49:56 server id 101 end_log_pos 964 CRC32 0x97eab2e2 Query thread_id=9 exec_time=0 error_code=0
|
SET TIMESTAMP=1597765796/*!*/;
|
GRANT Alter, Alter Routine, Create, Create Routine, Create Temporary Tables, Create User, Create View, Delete, Drop, Event, Execute, File, Grant Option, Index, Insert, Lock Tables, Process, References, Reload, Replication Client, Replication Slave, Select, Show Databases, Show View, Shutdown, Super, Trigger, Update ON *.* TO `cehau37_Copy1`@`193.1.1.2`
|
/*!*/;
|
# at 964
|
#200818 22:50:37 server id 101 end_log_pos 1006 CRC32 0x39ea522d GTID 0-101-79 ddl
|
/*!100001 SET @@session.gtid_seq_no=79*//*!*/;
|
# at 1006
|
#200818 22:50:37 server id 101 end_log_pos 1106 CRC32 0x37325f6f Query thread_id=9 exec_time=0 error_code=0
|
SET TIMESTAMP=1597765837/*!*/;
|
DROP USER `cehau37_Copy1`@`193.1.1.2`
|
Please help