5 Simple Steps Implement Replication in MySQL

Step 1: Create slave user with replication permission on master server

mysql> grant replication slave on *.* to 'slave'@'host' identified by 'slavepassword';

Step 2: Configure my.cnf on the master server

log-bin=C:\mysql-bin\
binlog_format=mixed
server-id = 1

Step 3: Configure my.cnf on the slave server

server-id = 2
master-host = masterhost
master-user = slave
master-password = slavepassword
master-port = 3306

Step 4: Restart MySQL service on both server

Step 5: Finish!