Skip to content
MAMP PRO Documentation

How do I determine the default MySQL Storage Engine?

  1. Open MAMP PRO and start the servers.

  2. Open Terminal (/Applications/Utilities/Terminal.app).

  3. Change to the MySQL binary directory:

    cd /Applications/MAMP/Library/bin
  4. Connect to the MySQL server:

    ./mysql --host=localhost -u root -proot
  5. Select the information_schema database:

    USE information_schema;
  6. Query the storage engines:

    SELECT * FROM engines;
  7. In the result table, look for the row in the Support column with the value DEFAULT — that is the active default storage engine.

  8. Exit the MySQL prompt:

    exit;

MySQL how-to guides