mac如何開啟mysql bin-log

expire_logs_days?=?5?定期清理 log-bin?=?/usr/local/var/mysql/mysql_bin_log/mysql-bin?#開啟binlog,指定文件聞之 server_id?=?1?#配置mysql?replication需要定義，不能和canal的slaveId重復(fù) binlog_format=MIXEDD

/*!50530?SET?@@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003?SET?@OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER?/*!*/; #?at?4 #200423?16:43:25?server?id?1??end_log_pos?123?CRC32?0xb303c132?????Start:?binlog?v?4,?server?v?5.7.29-log?created?200423?16:43:25?at?startup #?Warning:?this?binlog?is?either?in?use?or?was?not?closed?properly. ROLLBACK/*!*/; #?at?123 #200423?16:43:25?server?id?1??end_log_pos?154?CRC32?0x21d20383?????Previous-GTIDs #?[empty] #?at?154 #200423?16:45:11?server?id?1??end_log_pos?219?CRC32?0xfb334efd?????Anonymous_GTID????last_committed=0????sequence_number=1????rbr_only=no SET?@@SESSION.GTID_NEXT=?'ANONYMOUS'/*!*/; #?at?219 #200423?16:45:11?server?id?1??end_log_pos?295?CRC32?0xb8e6b396?????Query????thread_id=4????exec_time=0????error_code=0 SET?TIMESTAMP=1587631511/*!*/; SET?@@session.pseudo_thread_id=4/*!*/; SET?@@session.foreign_key_checks=1,?@@session.sql_auto_is_null=0,?@@session.unique_checks=1,?@@session.autocommit=1/*!*/; SET?@@session.sql_mode=1436549152/*!*/; SET?@@session.auto_increment_increment=1,?@@session.auto_increment_offset=1/*!*/; /*!C?utf8?*//*!*/; SET?@@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/; SET?@@session.lc_time_names=0/*!*/; SET?@@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; #?at?295 #200423?16:45:11?server?id?1??end_log_pos?626?CRC32?0xa15900c0?????Query????thread_id=4????exec_time=0????error_code=0 use?`chunyu`/*!*/; SET?TIMESTAMP=1587631511/*!*/; UPDATE?`article_article`?SET?`created_time`?=?'2020-04-23?08:17:20.953805',?`last_modified`?=?'2020-04-23?08:45:11.324532',?`user_id`?=?1,?`title`?=?'1',?`content`?=?'999999',?`status`?=?1,?`comment_count`?=?0,?`star_count`?=?0?WHERE?`article_article`.`id`?=?2 /*!*/; #?at?626 #200423?16:45:11?server?id?1??end_log_pos?657?CRC32?0xeb7a6863?????Xid?=?14 COMMIT/*!*/; SET?@@SESSION.GTID_NEXT=?'AUTOMATIC'?/*?added?by?mysqlbinlog?*/?/*!*/; DELIMITER?; #?End?of?log?file /*!50003?SET?COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530?SET?@@SESSION.PSEUDO_SLAVE_MODE=0*/;