Skip to main content
Database Admin RequiredYou need root or admin privileges to perform these steps.
Follow these steps to enable CDC for MySQL.
1

​
1. Enable binary logging

Add to my.cnf or my.ini:
[mysqld]
log_bin = mysql-bin
binlog_format = ROW
Restart MySQL. For MySQL 8.0+, binlog_format defaults to ROW in many configurations.
2

​
2. Enable log_bin_trust_function_creators (if needed)

If you use stored procedures or functions:
SET GLOBAL log_bin_trust_function_creators = 1;
3

​
3. Grant replication privileges

GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'mantrixflow'@'%';
FLUSH PRIVILEGES;
4

​
4. Verify binary log

SHOW VARIABLES LIKE 'log_bin';
SHOW VARIABLES LIKE 'binlog_format';
log_bin should be ON and binlog_format should be ROW.
After completing these steps, configure the MySQL source connection and run a pipeline with CDC sync mode.