1、主库需改配置文件，在/etc/my.cnf中添加：

2. port = 3306
3. log_bin = /var/lib/mysql/mysql-binlog
4. server-id = 1 //只要主从不一样就行
5. binlog_do_db = test//要做同步的数据库名字，可以是多个数据库，之间用分号分割。

2、从库的配置文件中添加

2. server-id = 2
3. master-host = 10.4.14.168 //主库的ip地址
4. master-user = gechong //同步的mysql账号
5. master-password = gechong //同步的mysql密码
6. master-port = 3306
7. master-connect-retry = 5
8. replicate-do-db = test //数据库名

3、分别重启服务，登陆数据库。

4、主库上创建复制用户

2. mysql> GRANT REPLICATION SLAVE,REPLICATION CLIENT ON *.* TO gechong@'%' IDENTIFIED BY 'gechong';

5、在主库上执行

2. mysql> show master status;
3. +---------------+----------+--------------+------------------+
4. | File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
5. +---------------+----------+--------------+------------------+
6. | binlog.000003 | 412 | | |
7. +---------------+----------+--------------+------------------+
8. 1 row in set (0.00 sec)

6、从库上执行

2. mysql> show slave status\G