Advertisement
Guest User

Untitled

a guest
Aug 2nd, 2016
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. CREATE USER 'repuser'@'%' IDENTIFIED BY 'reppass';
  2. GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
  3.  
  4. CHANGE MASTER TO
  5. master_host='10.20.30.40',
  6. master_port=3306,
  7. master_user='repuser',
  8. master_password='reppass',
  9. master_log_file='dummy',
  10. master_log_pos=1;
  11.  
  12. START SLAVE;
  13. DO SLEEP(10);
  14. SHOW SLAVE STATUSG
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement