Required database, user accounts, and schemas
Before you create a CDC Replication instance you need to ensure that you have the required database, user account, and directory access.
Configuring a MySQL database
When you configure the CDC Replication Engine for MySQL Source, you are prompted for the name of the MySQL database that you want CDC Replication to connect to and replicate data. The schema name is the same as the database name. Before installing the software, ensure that this MySQL database exists and that you have created and set up a database user that has access to it.
Setting up a Windows user account
If you are installing CDC Replication on a Windows system, you must set up a new, or decide on an existing Windows account that you will use to install, configure, or upgrade CDC Replication
Setting up a user account
When you are installing CDC Replication on a machine, you must set up a new, or decide on an existing account that you will use to install, configure, or upgrade CDC Replication. You can install CDC Replication in the directory of your choice, however, it must be owned by the account.
Setting up a MySQL user account with replication privileges
For CDC Replication to connect to your MySQL database, you need to create a MySQL user account and assign replication privileges to this user.
The following privileges are required for CDC Replication to access database tables:
GRANT ALL ON *.* TO ‘db_user’@’hostname';
GRANT ALL ON *.* TO db_user@'%’;