Last Updated: 2013-11-01
Condition or Error
The configuration of MySQL was wrong; it included
autocommit=0
and the
wrong server-id
Causes
Pre-requisites were not followed correctly.
Rectifications
Edit my.cnf
and
clean up. Restart MySQL if possible. Alternatively, set
manually:
mysql>set GLOBAL autocommit=1;
Query OK, 0 rows affected (0.00 sec) mysql>set GLOBAL server_id=2;
Query OK, 0 rows affected (0.01 sec)