在配置文件 /etc/my.cnf
添加变量 log-bin
:
log-bin=/var/lib/mysql/mybinlog/mysql-bin
重启数据库服务报错:
[root@htlwk0001host lib]# systemctl start mysqld.service
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
解决方案:
log-bin
和 server-id
要一起设置,才不会报错:
log-bin=/var/lib/mysql/mybinlog/mysql-bin
server-id=1