How Tos > 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.