0 rows affected (0.00 sec) mysql> reset slave; Query OK - Eduguru

MySQL Cluster

ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log

September 4, 2014May 21, 2015 eduguru 0 Comments 0 rows affected (0.00 sec) mysql> CHANGE MASTER TO MASTER_HOST='127.0.0.1', 0 rows affected (0.00 sec) mysql> reset slave; Query OK, 0 rows affected (0.06 sec), ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log, I have noticed one issue here : mysql> CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_LOG_FILE='mysql-bin.000000', MASTER_LOG_POS=12345; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log In the error log i didn't see anything, MASTER_LOG_POS=12345; Query OK, MASTER_PASSWORD = 'pass', MASTER_PASSWORD = 'password', MASTER_PORT=53306, MASTER_USER='username', so after googling some time I found the solution: mysql> flush slave; Query OK

I have noticed one issue here : mysql> CHANGE MASTER TO MASTER_HOST=’127.0.0.1′, MASTER_PORT=53306, MASTER_USER=’username’, MASTER_PASSWORD = ‘password’, MASTER_LOG_FILE=’mysql-bin.000000′, MASTER_LOG_POS=12345; ERROR