mysql主从数据库操作

主：

show master status;

+-----------------+------------+-------------------+-----------------------+

| File                | Position     | Binlog_Do_DB   | Binlog_Ignore_DB |

+-----------------+------------+-------------------+-----------------------+

|    log.000003 |           98  | repl                 | mysql                    |

+-----------------+------------+-------------------+-----------------------+

从：

slave stop;

change master to master_host='192.168.1.222',master_user='repl',master_password='123456', master_log_file='log.000003' ,master_log_pos=98;

slave start;

show slave status/G;

 

其它基本配置google一片