You can now check the MySQL’s data directory if the binary log is created. You should find a file something like mysql-bin.000001. You will also find a file mysql-bin.index.
In the mysql-bin.index file you will find the list of all the binary logs. i.e. If you restart the server a multiple times you will find your mysql-bin.index to have something like
./mysql-bin.000001 ./mysql-bin.000002 ./mysql-bin.000003
Now try this query in the mysql prompt show master logs; It should show something like this, depending the no. of binary logs present.
mysql> show master logs; +------------------+-----------+ | Log_name | File_size | +------------------+-----------+ | mysql-bin.000004 | 9066115 | | mysql-bin.000005 | 117 | | mysql-bin.000006 | 98 | +------------------+-----------+
Now it is essential to add a user account which the replication will use, Since we are granting a permission, you need to log in with a root access to mysql, and then run the following command.
mysql> GRANT REPLICATION SLAVE ON *.* -> TO 'repl'@'192.168%' IDENTIFIED BY 'slavepass';
Flush the privileges using mysql> flush privileges
This should ideally make your master ready for Replication.