Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE USER 'repuser'@'%' IDENTIFIED BY 'reppass';
- GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
- CHANGE MASTER TO
- master_host='10.20.30.40',
- master_port=3306,
- master_user='repuser',
- master_password='reppass',
- master_log_file='dummy',
- master_log_pos=1;
- START SLAVE;
- DO SLEEP(10);
- SHOW SLAVE STATUSG
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement