Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to load data from a MySQL Community (Server version: 8.0.19 MySQL Community Server - GPL) installed in same machine that Replicate 6.5
my.ini
default-storage-engine=INNODB
log-bin="SENSE-bin"
binlog_format=row
binlog_checksum=NONE
When I try to create a task using this MySQL as a source, I'm getting this error:
Stream component 'st_0_MySQL' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_MySQL'.
Errors in MySQL server binary logging configuration
Error 2019 (Can't initialize character set unknown (path: compiled_in)) connecting to MySQL server 'localhost'
Can anyone point me one direction to check what can be done to solve this?
Solved
file path: %PROGRAMDATA%\MySQL\MySQL Server X.X\my.ini
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
skip-character-set-client-handshake
[client]
default-character-set = utf8
[mysql]
default-character-set = utf8
Solved
file path: %PROGRAMDATA%\MySQL\MySQL Server X.X\my.ini
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
skip-character-set-client-handshake
[client]
default-character-set = utf8
[mysql]
default-character-set = utf8