MYSQL configuration replicate error 1200 _ MySQL

For MYSQL configuration replicate, the error 1200 is returned. bitsCN.com

Master server: window XP, mysql 5.5

Slave server: window7, mysql 5.1

When starting The server slave, The system always prompts error 1200: The server is not configured as slave; fix in config file or with change master.

Use it directly on the slave server

Change master

Master_host = '1970. 168.1.103 ',

Master_user = 'repl ',

Master_password = '000000 ',

Master_log_file = 'master-bin.000001 ', # consistent with the master server

Master_log_pos = 107; # consistent with the master server

You can start slave or report this error.

The younger brother really collapsed and asked you again.

The following is my. ini configuration of the master/slave server:

Master:

Server-id = 1

Log-bin = C:/Program Files/MySQL Server 5.5/master-bin.log

Binlog-do-db = ld

Binlog-ignore-db = mysql

Log-error = C:/Program Files/MySQL Server 5.5/master-error.log

Relay-log = C:/Program Files/MySQL Server 5.5/slave-relay.log

Relay-log-info-file = C:/Program Files/MySQL Server 5.5/slave-relay-log.info

Relay-log-index = C:/Program Files/MySQL Server 5.5/slave-relay-log.index

Max_connections = 500

From:

Service-id = 2

Master-host = 192.168.1.103

Master-user = repl

Masters-password = 111111

Master-port = 3306

Replicate-do-db = ld

Log-bin = mysql-bin

Author shadow_dance

BitsCN.com