Run PowerExchange and the mysqlbinlog utility on the MySQL source database server.
Run PowerExchange and the mysqlbinlog utility on a machine that is remote from the MySQL source database server. Either specify the mysqlbinlog path in the Path environment variable or specify the mysqlbinlog full path and file name in the MYSQLBINLOG parameter in the MYSQL CAPI_CONNECTION statement in the dbmover configuration file.

Set the ODBCINI and ODBCINST environment variables. Use the following export statements:
export ODBCINI=$PWX_HOME/ODBC7.1/odbc.ini
export ODBCINST=$PWX_HOME/ODBC7.1/odbcinst.ini
Set the shared LD_LIBRARY_PATH environment variable. Use the following statements:
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$PWX_HOME/ODBC7.1/lib; 
export LD_LIBRARY_PATH
Update the ODBC driver information in the odbc.ini and odbcinst.ini files. For example, add the following statement:
Driver=
pwx_home/ODBC7.1/lib/DWmysql27.so
The
pwx_home
variable represents the local path to the DataDirect installation that PowerExchange uses.

If you start the MySQL database server from the command line, enter the following command:

mysqld --server-id[=
server_id] --log-bin[=
base_name] --binlog-format[=row]  
--binlog-row-image[=full]

If you start the MySQL database server as a service on Windows or as a daemon on Linux, you can specify database configuration settings in an .ini or .cnf configuration file. The default file, my.ini, is located in the MySQL installation directory. To enable binary logging, add the following lines to your MySQL configuration file:

[mysqld]
server-id=
server_id
log-bin=
base_name
binlog-format=row
binlog-row-image=full

CREATE USER '
pwx_user'@'%' IDENTIFIED BY '
password';

GRANT SELECT ON 
database_name.* TO '
pwx_user'@'%';
GRANT REPLICATION CLIENT ON *.* TO '
pwx_user'@'%';

GRANT REPLICATION SLAVE ON 
database_name.* TO '
pwx_user'@'%';