> ## Content Index
> Fetch the complete content index at: https://oyang.cc/llms.txt
> Use this file to discover other available public pages before exploring further.

# MySQL开启binlog日志
- URL: https://oyang.cc/mysqlkai-qi-binlogri-zhi/
- Published: 2020-03-20T14:47:25.000Z
- Updated: 2020-03-20T14:47:27.000Z
- Author: 轶语林
- Tags: mysql

### 编辑mysql配置文件 `/etc/my.cnf` 在`[mysqld]` 区块下

```
log-bin=mysql-bin
max_binlog_size = 1g

```