vi /etc/my.cnf
log_bin = mysql-bin
server_id = 67
重启mysql 服务
service mysqld restart
登陆mysql
mysql -u root -pReport@123
登陆数据库查看是否开启二进制日志功能
mysql>show variables like "log%";
log_bin | ON
vi /etc/my.cnf
log_bin = mysql-bin
server_id = 67
重启mysql 服务
service mysqld restart
登陆mysql
mysql -u root -pReport@123
登陆数据库查看是否开启二进制日志功能
mysql>show variables like "log%";
log_bin | ON