Ubuntu18.04 MySQL开启binlog日志
1. 修改配置文件
sudo /etc/mysql/mysql.cnf # 添加以下内容，具体要看你的配置文件是哪个
[mysqld]
server_id = 1
log_bin = /var/log/mysql/mysql-bin.log
2. 重启MySQL数据库
sudo service mysql restart
3. 进入mysql
1. 创建一个用户test1
create user test1@'localhost' identified by '123456';
2. 查看binlog日志内容
sudo mysqlbinlog /var/log/mysql/mysql-bin.000001 |more
image
