<\/span><\/h2>\n\n\n\nOpen terminal on master database’s server and run the following command<\/p>\n\n\n\n
$ sudo vi \/etc\/mysql\/my.cnf<\/pre>\n\n\n\nBy default, remote connections are disabled in MySQL. We need to allow remote connection from slave to master for replication. So we uncomment the following two lines to allow remote connections, by adding # at their beginning, as shown below<\/p>\n\n\n\n
#skip-networking\n#bind-address=127.0.0.1<\/pre>\n\n\n\nAdd or uncomment the following lines in [mysqld] block to look like the following.<\/p>\n\n\n\n
[mysqld]<\/code>\nserver-id=1<\/code>\nlog-bin = \/var\/log\/mysql\/mysql-bin.log\nbinlog-do-db=exampledb<\/code><\/pre>\n\n\n\nLet us look at each of the above line. The first line server-id specifies a unique ID number for master. It needs to be a positive number from 1 to 2^32.<\/p>\n\n\n\n
log-bin<\/em> specifies the log file location that will be populated by MySQL with details of replication.<\/p>\n\n\n\nbinlog-do-db<\/em> indicates the name of database that needs to be replicated.<\/p>\n\n\n\nRestart MySQL Server to apply changes<\/p>\n\n\n\n
$ sudo service mysql restart<\/pre>\n\n\n\nLog into MySQL as root user<\/p>\n\n\n\n
$ sudo mysql -u root -p<\/pre>\n\n\n\nand run the following command<\/p>\n\n\n\n
mysql> SHOW MASTER STATUS;\n+------------------+----------+--------------+------------------+\n| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |\n+------------------+----------+--------------+------------------+\n| mysql-bin.000001 | 107 | exampledb | |\n+------------------+----------+--------------+------------------+<\/pre>\n\n\n\nPlease note the above details, we will need them later in Step #3.<\/p>\n\n\n\n
<\/p>\n\n\n\n