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.
- Stop the MAMP Servers that are running.
- Use a text editor to create a file named “my.cnf” and save it to the “/Applications/MAMP/conf” folder.
- Add the following lines into the file:
[mysqld]default-storage-engine = InnoDB
- Save the file and close your editor.
- Start the MAMP servers.