Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to solve 1200 errors in MYSQL configuration replicate". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Primary server: window XP, 5.5

Slave server: window7,mysql 5.1

When you start slave from the server, you always prompt error 1200:The server is not configured as slave; fix in config file or with CHANGE MASTER.

In direct use from the server

Change master to

Master_host='192.168.1.103'

Master_user='repl'

Master_password='111111'

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

Master_log_pos=107;## is consistent with the primary server

But start slave still reported this error.

My little brother was really devastated. I asked the great gods for advice again.

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

Lord:

Server-id=1

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

Binlog-do-db=ld

Binlog-ignore-db=mysql

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

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

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

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

Max_connections=500

From:

Service-id=2

Master-host=192.168.1.103

Master-user=repl

Master-password=111111

Master-port=3306

Replicate-do-db=ld

Log-bin=mysql-bin

This is the end of the content of "how to solve the 1200 error in MYSQL configuration replicate". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.