create root user on mysql

add_user.sql

-- create a root user at 192.168.11.0/24
CREATE USER 'root'@'192.168.11.%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

-- create a replication user
CREATE USER repl_user;
GRANT REPLICATION SLAVE ON *.* TO repl_user IDENTIFIED BY 'some_pass';

-- start reolication on slave
CHANGE MASTER TO MASTER_HOST = 'master', MASTER_PORT = 3306, MASTER_USER = 'repl_user', MASTER_PASSWORD = 'some_pass';
START SLAVE;