主
安装数据库

主IP 192.168.0.59

辅助：IP 192.168.0.60


apt-get install mysql-server mysql-client

修改my.cnf见附件

1.mysql_install_db --user=mysql --datadir=/home/data/db/mysql

2.cat /etc/mysql/debian.cnf |grep password |head -n 1|awk '{print $3}'

oaoUdbzsGY0f4cgO
3.登入mysql执行

>GRANT ALL ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD 'oaoUdbzsGY0f4cgO';
use mysql
update user set Password = password('oaoUdbzsGY0f4cgO') where User='debian-sys-maint';
FLUSH PRIVILEGES;

初始化完毕

mysql>

grant replication slave on *.* to 'repl_user'@'192.168.0.60' identified by 'repl_123';
show master status;

mysql> show master status;
+------------------+----------+--------------+--------------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB         |
+------------------+----------+--------------+--------------------------+
| mysql-bin.000003 |      193 |              | mysql,information_schema |
+------------------+----------+--------------+--------------------------+
1 row in set (0.00 sec)
辅助：安装数据库已经初始化数据库同上

修改my.cnf见附件

 

mysql>

change master to master_host=192.168.0.59',master_user='repl_user',master_password='repl_123',master_port=3306,master_log_file='mysql-bin.000003',master_log_pos=193;

slave start;

show slave status\G