|
|
mysql> change master to master_host='192.168.100.10',master_user='replication',master_password='123456',master_log_file='updatelog.000004',master_log_pos=106;- g) j5 p3 m3 Y6 Q
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
- g. q Z; L* ]! p- H4 w- n2 V( h8 F. {
很好的解决办法(如下)：: l: g2 Z& P& B y( k F
mysql> slave stop;8 p( f C! ^$ i, D2 s1 H
Query OK, 0 rows affected, 1 warning (0.00 sec)
- a- Z4 P t- h+ {) G
" i4 F( y6 D/ U( Y' _/ {9 bmysql> reset slave;, U1 p6 c' u/ v1 Z) o
X! X: y2 j% D3 x$ i
Query OK, 0 rows affected,(0.00 sec)) X( w0 K% ^3 m; _/ C' S8 R: _
- j0 u4 I9 ~. @, Y( b
mysql> change master to master_host='192.168.100.10',master_user='replication',master_password='123456',master_log_file='updatelog.000004',master_log_pos=106;
( }8 B) X5 M% vQuery OK, 0 rows affected (0.05 sec)
5 }7 N; M8 |9 S. T; Tmysql> slave start;
0 ?$ K2 w9 _ r+ n" {- H6 n7 o% z; LQuery OK, 0 rows affected (0.00 sec)9 |3 n4 w- l3 e, K0 j
. ]0 z( {6 L6 O0 W5 J [0 e |
|
发表于 2018-7-5 15:09:31