demo for mysql update/insert log

1.Login Mysql

cd C:\mysql5\bin;

https://blog.csdn.net/weixin_44797182/article/details/90639195

mysql -uroot -p;   or   mysql -h 110.110.110.110 -uroot -p abcd123;

2.check binlog status

show variables like 'log_bin';

https://blog.csdn.net/yssa1125001/article/details/87866289?depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-13&utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-13

3.show logs

show binlog events in 'xxx.000001';

4.del logs

reset master;

5.exist

exist;