mysql 主从

mysql> GRANT REPLICATION SLAVE ON *.* TO repl@192.168.138.162 IDENTIFIED BY '123456';

 

mysql> change master to
-> master_host='192.168.138.161',
-> master_user='repl',
-> master_password='replication',
-> master_log_file='mysql-bin.000001',
-> master_log_pos=2606;