title: change mysql default engine to innodb
body: <p>I am using mac and I installed mysql using homebrew. </p>
  
  <pre><code>brew install mysql
  </code></pre>
  
  <p>pretty standard installation.</p>
  
  <pre><code>mysql&gt; show engines;
  +------------+---------+------------------------------------------------------------+--------------+------+------------+
  | Engine     | Support | Comment                                                    | Transactions | XA   | Savepoints |
  +------------+---------+------------------------------------------------------------+--------------+------+------------+
  | MRG_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         |
  | CSV        | YES     | CSV storage engine                                         | NO           | NO   | NO         |
  | MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         |
  | InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
  | MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |
  +------------+---------+------------------------------------------------------------+--------------+------+------------+
  </code></pre>
  
  <p>I would like innodb to be the default storage engine. What do I need to do?</p>