C.3.36. 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

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)