MySQL enable binlog

Angryshark_ one hundred and twenty-eight 2022-06-24 07:15:03 阅读数:277

mysqlenablebinlog

Check to see if it's on

> show variables like '%log_bin%';

 Insert picture description here

Modify the configuration file

> vi my.cnf
server_id=1918
log_bin = mysql-bin
binlog_format = ROW

Check to see if it's on

> show variables like '%log_bin%';

 Insert picture description here

copyright:author[Angryshark_ one hundred and twenty-eight],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/175/202206240050386090.html