Open and view MySQL's Bin-log log

[Email protected]_0_7_centos data]# vim/etc/my.cnf [email protected]_0_7_centos data]# vim/etc/my.cnf [email protect Ed]_0_7_centos data]#/etc/init.d/mysqld restartshutting down MySQL .... success! Starting MySQL. success! [[Email Protected]_0_7_centos data]# grep log_bin/etc/my.cnf [[email protected]_0_7_centos data]# grep log-bin/etc/my.c NF 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)

　　

To open and view MySQL Bin-log logs