自宅サーバにて試す。

IT

▼マスタ側

$ vi /etc/my.cnf
----------------------------------------------
# Replication Master Server (default)
# binary logging is required for replication
log-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id       = 789
----------------------------------------------

再起動
# /etc/init.d/mysql restart
Restarting service MySQL
Shutting down service mysql
                                                                     done
Starting service MySQL

スレーブからマスタに接続する際に使用する
ユーザ名＆パスワードを定義し、
このユーザ(repl)にREPLICATION SLAVE権限を与える。

mysql> grant replication slave on *.* to 'repl'@'192.168.1.9' identified by 'pass';
Query OK, 0 rows affected (0.00 sec)

▼スレーブ側

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
server-id=9990
master-host="192.168.1.1"
master-user='repl'
master-password='pass'
master-port=3306

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid