mysql-5.6主从复制及遇到的错误(三)
master'@'192.168.254.153' (using password: YES) (Errno: 1045), Error_code: 1597
2013-09-22 15:39:21 2150 [ERROR] Slave I/O thread couldn't register on master
错误原因,没有在master上给master用户授权!!
mysql> select * from hi_tb; (master)
+------+------+
| id | name |
+------+------+
| 1 | bobu |
| 2 | dsfa |
+------+------+
mysql> select * from hi_tb; (slave)
+------+------+
| id | name |
+------+------+
| 1 | bobu |
| 2 | dsfa |
+------+------+
2 rows in set (0.01 sec)
实现了同步。
最后,再次对比一下主从的二进制日志