How to solve the problem of ERROR 1201 (HY000) errors in MySQL

This article mainly introduces "how to solve the problem of ERROR 1201 (HY000) error in MySQL". In daily operation, I believe many people have doubts about how to solve the problem of ERROR 1201 (HY000) error in MySQL. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt of "how to solve the problem of ERROR 1201 (HY000) error in MySQL". Next, please follow the editor to study!

Configure mysql master-slave replication. Start slave is an error: ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log

Reason: have done master-slave replication before

Solution:

Mysql > stop slave

Query OK, 0 rows affected, 1 warning (0.00 sec)

Mysql > reset slave

Query OK, 0 rows affected (0.00 sec)

Mysql > CHANGE MASTER TO

-> MASTER_HOST='192.168.122.10'

-> MASTER_PORT=3306

-> MASTER_USER='repl'

-> MASTER_PASSWORD='repl'

-> MASTER_LOG_FILE='mysql-bin.000015'

-> MASTER_LOG_POS=192

Query OK, 0 rows affected (0.14 sec)

Mysql > start slave

Query OK, 0 rows affected (0.07 sec)

At this point, the study on "how to solve the problem of ERROR 1201 (HY000) errors in MySQL" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!