remove MySQL AUTOCOMMIT setting; Related #1679

It's not needed, it ruins any autocommit value you have set yourself,
and it blocks manually locking of tables