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. 創(chuàng)建一個用戶test1
create user test1@'localhost' identified by '123456';
2. 查看binlog日志內容
sudo mysqlbinlog /var/log/mysql/mysql-bin.000001 |more
image
