Sources - MySQL - Self-hosted MySQL

Create user

Create a sync user for Integrate.io by executing,
CREATE USER 'flydata'@'%' IDENTIFIED BY '<your_password>';

Grant necessary privileges,

GRANT SELECT, RELOAD, REPLICATION SLAVE, REPLICATION CLIENT, LOCK TABLES ON *.* TO 'flydata'@'%';
FLUSH PRIVILEGES;

Enable binary logging

Set the following properties in the MySQL configuration file (typically available in the /etc/mysql/ directory).
[mysqld]
log_bin = mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800
binlog_row_image = FULL
net_read_timeout = 3600
net_write_timeout = 3600
wait_timeout = 86400

Confirm your changes by checking the binlog status,

SHOW GLOBAL VARIABLES LIKE 'log_bin';