sql master slave

1.master

vi /etc/my.cnf

[mysqld]
log-bin=mysqlbin-log
server-id=17


grant replication slave on *.* to 'slave'@'%' identyfied by '123456';
show master status;



2.slave
vi /etc/my.cnf

server-id=18


change master to master_host='',master_user='slave',master_password='123456',master_log_file='',master_log_pos='';

start slave;
show slave status\G;