|
|
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;
4 b- I# m; _. G8 q2 h& gERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
( B' |/ J% M3 Q! W3 Y$ e7 h" X4 z4 X( u
很好的解决办法(如下)：2 M) m! _! T9 g) j4 R% O4 N
mysql> slave stop;
2 L2 q4 w8 d/ x, u. V0 ?Query OK, 0 rows affected, 1 warning (0.00 sec)6 B" g" L3 D' L8 Z: C
) j% N7 X3 e o
mysql> reset slave;
- o; T9 f* t, q* z" {3 [% ~( T
6 w) s2 Y4 {5 W: [6 }! eQuery OK, 0 rows affected,(0.00 sec)& E; i3 N. Y) D
9 \% {& R2 J8 r+ F3 P' `, _+ R% P umysql> change master to master_host='192.168.100.10',master_user='replication',master_password='123456',master_log_file='updatelog.000004',master_log_pos=106;
0 k1 y6 k" @. J' z0 CQuery OK, 0 rows affected (0.05 sec)
# _' @; p8 W0 W# G% G! B) ~mysql> slave start;
2 e/ I# ]9 s, v, \# f: B5 EQuery OK, 0 rows affected (0.00 sec)
* x- V" i# W$ @8 H3 D+ _) ?* q& e$ W8 A
|
|
发表于 2018-7-5 15:09:31