ERROR1201 (HY000): Couldnotinitializemasterinf

(Conversion) An error "ERROR1201 (HY000)" occurred during MySQL master-slave replication: Couldnotinitializemasterinfostructure. This problem occurs because I have performed master-slave replication before! Solution: run the stopslave command. After the command is successfully executed, run resetslave and reset master-slave replication. The specific process is as follows:

(Conversion) An ERROR 1201 (HY000) occurs during MySQL master-slave replication: cocould not initialize master info structure. The cause of this problem is that you have performed master-slave replication before! Solution: run the stop slave command. After the command is successfully executed, run reset slave and reset master-slave replication. The specific process is as follows:

(Conversion) An ERROR 1201 (HY000): cocould not initialize master info structure occurs during MySQL master-slave replication.
The reason for this problem is that you have performed master-slave replication before!

Solution:

Run the stop slave command;
Run reset slave successfully;
Then reset master-slave replication.

The specific process is as follows:

Mysql> change master to master_host = '192. 0.0.1 ', master_user = 'user', master_pass
Word = 'user', master_log_file = 'mysql-bin-000202 ', master_log_pos = 553;
ERROR 1201 (HY000): cocould not initialize master info structure; more error messa
Ges can be found in the MySQL error log
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. 0.0.1 ', master_user = 'user', master_pass
Word = 'user', master_log_file = 'mysql-bin-000202 ', master_log_pos = 553;
Query OK, 0 rows affected (0.11 sec)

Original article address: ERROR 1201 (HY000): cocould not initialize master inf, thanks to the original author for sharing.