mysql查询bin-log日志_MySQL数据库之开启和查看mysql的bin-log日志

本文主要向大家介绍了MySQL数据库之开启和查看mysql的bin-log日志 ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。

[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 restart

Shutting 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 away

No connection. Trying to reconnect...

Connection id:    2

Current 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)

以上就介绍了MySQL的相关知识，希望对MySQL有兴趣的朋友有所帮助。了解更多内容，请关注职坐标数据库MySQL频道！