Skip to content
MAMP PRO Documentation

How do I define the default MySQL Storage Engine?

The MySQL server in MAMP PRO uses MyISAM as the default storage engine. The following steps show how to change it to InnoDB.

  1. Start MAMP PRO.

  2. Stop the servers if they are running.

  3. Go to File › Open Template › MySQL (my.cnf) › [version].

  4. An editor window opens. If a warning message appears, confirm with OK.

    MAMP PRO - Open MySQL template - Warning

  5. Find the [mysqld] section.

  6. Add the following line at the end of the [mysqld] section:

    default-storage-engine = InnoDB

  7. Save the file (⌘ S).

  8. Close the editor (⌘ W).

  9. Start the servers.

← MySQL how-to guides