Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement