C.3.35. MySQL is incorrectly configured

Last Updated: 2013-11-01

Condition or Error

The configuration of MySQL was wrong; it included autocommit=0 and the wrong server-id


  • Pre-requisites were not followed correctly.


  • 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)