Once you have a mysql console / command line / prompt:
SET autocommit=0;
E.g.
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 53 Server version: 5.0.45 Source distribution Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer. mysql> use your_db_here Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SET autocommit=0; Query OK, 0 rows affected (0.00 sec)<strong></strong>