1授权
-- 使用命令登录:mysql -u root -p
-- 创建用户 用户名:canal 密码:Canal@123456
create user 'canal'@'%' identified by 'Canal@123456';
-- 授权 *.*表示所有库
grant SELECT, REPLICATION SLAVE, REPLICATION CLIENT on *.* to 'canal'@'%' identified by 'Canal@123456';
2,查看是否开启
show variables like 'log_bin'
3,修改配置文件 my.cnf或者my.inni
[mysqld]
# 打开binlog
log-bin=mysql-bin
# 选择ROW(行)模式
binlog-format=ROW
# 配置MySQL replaction需要定义,不要和canal的slaveId重复
server_id=1
4,查看binlog日志文件列表:
show binary logs;
5查看当前正在写入的binlog文件:
show master status
INSERT INTO tb_commodity_info VALUES('3e71a81fd80711eaaed600163e046c11','叉烧包','3.99',3,'又大又香的叉烧包,老人小孩都喜欢');
SELECT * FROM tb_commodity_info