Enable and view mysql bin-log and mysqlbin-log

Enable and view mysql bin-log and mysqlbin-log

[root@VM_0_7_centos data]# vim /etc/my.cnf [root@VM_0_7_centos data]# vim /etc/my.cnf [root@VM_0_7_centos data]# /etc/init.d/mysqld restartShutting down MySQL.... SUCCESS! Starting MySQL. SUCCESS! [root@VM_0_7_centos data]# grep log_bin /etc/my.cnf [root@VM_0_7_centos data]# grep log-bin /etc/my.cnf log-bin=/opt/mysql/data/mysql-bin

mysql> show variables like '%log_bin%';ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect...Connection id:    2Current database: wordpress+---------------------------------+---------------------------------+| Variable_name                   | Value                           |+---------------------------------+---------------------------------+| log_bin                         | ON                              || log_bin_basename                | /opt/mysql/data/mysql-bin       || log_bin_index                   | /opt/mysql/data/mysql-bin.index || log_bin_trust_function_creators | OFF                             || log_bin_use_v1_row_events       | OFF                             || sql_log_bin                     | ON                              |+---------------------------------+---------------------------------+6 rows in set (0.01 sec)