FAQ > MySQL and Databases

How do I define the default MySQL Storage Engine?

The MySQL server of MAMP PRO uses the Default Storage Engine MyISAM. If you want to change this, you have to change the configuration file of the MySQL server. With this tutorial we want to show you how to manage this. As Default Storage Engine we are using InnoDB.

  1. Start MAMP PRO.
  2. Stop the MAMP PRO server if it is running.
  3. Select File > Open Template > MySQL my.cnf > 5.7.30
  4. An editor window appears.
  5. If a warning message appears confirm with OK.
    MAMP PRO - Open MySQL template - Warning
  6. Find the section [mysqld]
  7. Beneath the last line of this section add this line:
    default-storage-engine = InnoDB
  8. Save (Apple + S) all changes made on “my.cnf”
  9. Close the editor window (Apple + W)
  10. Start the MAMP PRO servers.