Last Updated: 2013-11-01
Condition or Error
The configuration of MySQL was wrong; it included
autocommit=0 and the
wrong server-id
Causes
Prerequisites 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)