FAQ

How do I set the MySQL Default Storage Engine?

The MySQL server of MAMP uses the Default Storage Engine MyISAM. If you want to change this to a different storage engine such as InnoDB you have to change the configuration file of the MySQL server.

  1. Stop the MAMP Servers that are running.
  2. Use a text editor to create a file named “my.cnf” and save it to the “/Applications/MAMP/conf” folder.
  3. Add the following lines into the file:
    [mysqld]default-storage-engine = InnoDB
  4. Save the file and close your editor.
  5. Start the MAMP servers.