docker-mysql-replication/slave/init-db.sql

CREATE DATABASE IF NOT EXISTS xbrlgen;

GRANT ALL ON xbrlgen.* TO 'root'@'%' IDENTIFIED BY 'dodol123';

GRANT REPLICATION SLAVE ON *.* TO 'replica'@'%' IDENTIFIED BY 'duren123';

CHANGE MASTER TO MASTER_HOST='mysql-master', MASTER_USER='replica', MASTER_PASSWORD='duren123', MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=0;

FLUSH PRIVILEGES;

START SLAVE;