Advertisement
Guest User

Untitled

a guest
Sep 1st, 2016
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. Master mysql port = 3306
  2. master server id = 1
  3.  
  4. Slave mysql port = 3307
  5. slave server id =2
  6.  
  7. change master to
  8. master_host = 'masterIP',
  9. master_port=3306,
  10. master_user = 'username',
  11. master_password= 'password',
  12. master_log_file = 'mysql-bin.000037',
  13. master_log_pos = 89265280;
  14.  
  15. Start Slave;
  16.  
  17. Error Code: 1794. Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement