I'm running MySQL Workbench 5.2, and whenever I make a connection to a database auto commit is toggled on.
Is there any way to have the default behavior be changes so that auto commit is toggled off, I'm forgetful and don't want to cause a problematic committed updated just because I forgot to toggle it off manually.
Best Answer
Add this to /etc/my.cnf (Linux) or my.ini (Windows)
Restart of mysql required !!! :(
UPDATE 2011-08-03 12:18 EDT
In MySQL Workbench you need to make sure the Data Changes Wizard is enabled. Here is why:
Here is how to check:
If it is checked, data gets committed via a Wizard requiring user intervention.
If it is unchecked, data gets committed, bypassing MySQL's autocommit protocols.