修改办法:
vi /etc/my.cnf
在[mysqld]下添加:
log-bin=/mysql_data/mysql-bin
log-bin-index=/mysql_data/mysql-bin.index
log-bin-index=/mysql_data/mysql-bin.index
我的如下:
[mysqld]
datadir=/mysql_data
pid-file=/var/log/mysql/mysql.pid
log-bin=/mysql_data/mysql-bin
log-bin-index=/mysql_data/mysql-bin.index
datadir=/mysql_data
pid-file=/var/log/mysql/mysql.pid
log-bin=/mysql_data/mysql-bin
log-bin-index=/mysql_data/mysql-bin.index
重新启动mysql服务。