1、从服务器报错先查看主服务器的my.cnf文件中的server-id = XX行的id是不是与从服务的server-id = XX相同，相同的随便改一个一般取ip的最后一段

2、在主服务器重新查询bin-log文件及 position点，要先给用户设置权限

mysql> GRANT REPLICATION SLAVE ON *.* to 'lsx'@'%' identified by '123';
Query OK, 0 rows affected (0.00 sec)

mysql> show master status; 
+------------------+----------+--------------+------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000010 |      245 |              |                  |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

lsx设置为你要设置的用户123为用户密码查询后就不要在操作主服务器了。

3、在从服务器先停止slave

mysql> slave stop;   //停止slave
Query OK, 0 rows affected (0.01 sec)

mysql> change master to master_host='192.168.xxx',master_user='lsx',master_password='123',master_log_file='mysql-bin.000010',master_log_pos=245;   //为slave指定 master IP、用户名、密码、 bin-log文件名( mysql-bin.000010)及position(245)
Query OK, 0 rows affected (0.01 sec)

mysql> slave start;   //启动slave
Query OK, 0 rows affected (0.01 sec)

然后在从服务器上进行查询

mysql> show slave status\G

解决