Why is configuring init-file causing the error COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'binary'
7 Apr
2024
7 Apr
'24
6:11 a.m.
Why is configuring init-file causing the error COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'binary' I use default character-set-server=binary ❯ rg binary conf.d/mariadb.cnf 7:character-set-server=binary 8:collation-server=binary ❯ /usr/local/mysql/bin/mariadbd --init-file=/etc/mysql/init.sql --defaults-file=/etc/mysql/mariadb.cnf 2024-04-07 12:07:40 0 [ERROR] COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'binary' 2024-04-07 12:07:40 0 [ERROR] Aborting ❯ cat /etc/mysql/init.sql STOP SLAVE;CHANGE MASTER TO master_use_gtid=slave_pos, MASTER_USER='sync',MASTER_HOST='xx',MASTER_PORT=2002,MASTER_PASSWORD='xx',MASTER_CONNECT_RETRY=1; START SLAVE; /etc/mysql
221
Age (days ago)
221
Last active (days ago)
0 comments
1 participants
participants (1)
-
i18n.site