Mysql5.7.x无法开启二进制日志的解决方法

mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |     #二进制日志是关闭的
+---------------+-------+
1 row in set (0.00 sec)

mysql> 

log_bin=mysql-bin  #其中mysql-bin代表的是 name就是生成二进制日志文件的前缀部分,默认的位置在datadir目录下,也可以设置为其他的路径
server-id=11   #由于bug问题必须设置这个id，数字随便写

datadir=/var/lib/mysql   #默认指定文件存放位置，可修改，但是要注意权限

systemctl restart mysqld

mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |
+---------------+-------+
1 row in set (0.00 sec)

注：在my.cnf中设置好log-bin之后,log_bin自动设置为ON, name设置为mysql-bin,index文件也自动生成,index文件记录的就是所有的二进制文件的名称及位置信息.

mysql> show variables where variable_name in ('log_bin','log_bin_ name','log_bin_index');
+------------------+--------------------------------+
| Variable_name    | Value                          |
+------------------+--------------------------------+
| log_bin          | ON                             |
| log_bin_ name | /var/lib/mysql/mysql-bin       |
| log_bin_index    | /var/lib/mysql/mysql-bin.index |
+------------------+--------------------------------+
3 rows in set (0.01 sec)

mysql> 

If you specify the --log-bin option without also specifying a --server-id, the server is not allowed to start. (Bug #11763963, Bug #56739)