Disable AUTOCOMMIT in MySQL

When using the Storage engine InnoDB, MySQL supports transactions.
Per default AUTOCOMMIT is set to true.

mysql> select @@autocommit;
+----------------+
| @@autocommit |
+----------------+
| 1 |
+----------------+
1 row in set (0.00 sec)
See here for a the code to deactivate autocommit in mysql

For the current session use:
mysql> SET AUTOCOMMIT=0;
or for a global usage:

mysql> SET GLOBAL init_connect='SET AUTOCOMMIT=0';


This will be active for new sessions.
During Testing with the mysql command line utility, the @@autocommit was always 1.
The solution was in here. You have to use any user different than root, because for
root, the init_connect is not executed.

Define a user without SUPER privileges and autocommit will be set to 0 for the next
session.