mysql1200_关于MYSQL配置replicate出现1200异常

关于mysql配置replicate出现1200错误

主服务器:window XP,mysql 5.5

从服务器:window7,mysql 5.1

在从服务器start slave时&＃xff0c;一直提示error 1200:The server is not configured as slave; fix in config file or with CHANGE MASTER .

在从服务器上直接用

change master to

master_host&＃61;&＃39;192.168.1.103&＃39;,

master_user&＃61;&＃39;repl&＃39;,

master_password&＃61;&＃39;111111&＃39;,

master_log_file&＃61;&＃39;master-bin.000001&＃39;,##与主服务器一致

master_log_pos&＃61;107;##与主服务器一致

可start slave还是报这个错误。

小弟实在是崩溃了&＃xff0c;再次求教各位大神。

一下是主从服务器的my.ini配置&＃xff1a;

主&＃xff1a;

server-id&＃61;1

log-bin&＃61;C:/Program Files/MySQL/MySQL Server 5.5/master-bin.log

binlog-do-db&＃61;ld

binlog-ignore-db&＃61;mysql

log-error&＃61;C:/Program Files/MySQL/MySQL Server 5.5/master-error.log

relay-log&＃61;C:/Program Files/MySQL/MySQL Server 5.5/slave-relay.log

relay-log-info-file&＃61;C:/Program Files/MySQL/MySQL Server 5.5/slave-relay-log.info

relay-log-index&＃61;C:/Program Files/MySQL/MySQL Server 5.5/slave-relay-log.index

max_connections&＃61;500

从&＃xff1a;

service-id&＃61;2

master-host&＃61;192.168.1.103

master-user&＃61;repl

master-password&＃61;111111

master-port&＃61;3306

replicate-do-db&＃61;ld

log-bin&＃61;mysql-bin

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~