欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

开启和查看mysql的bin-log日志

程序员文章站 2022-10-30 22:48:38
[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 d... ......
[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的bin-log日志