Skip to content
MAMP Documentation

How do I check the Default Storage Engine of MySQL?

  1. Open MAMP.

  2. Start the servers.

  3. Open Terminal.app in /Applications/Utilities/.

  4. Navigate to the MySQL binary directory. Enter the path for your MySQL version and press Enter:

    • MySQL 5.7: cd /Applications/MAMP/Library/bin/mysql57/bin
    • MySQL 8: cd /Applications/MAMP/Library/bin/mysql80/bin

  5. Connect to MySQL and press Enter:

    ./mysql --host=localhost -u root -proot

  6. Select the information schema and press Enter:

    USE information_schema;

  7. Query the storage engines and press Enter:

    SELECT * FROM engines;

  8. A table with all storage engines appears. The default storage engine is marked as DEFAULT in the Support column.

    MAMP - Default Storage Engine of MySQL

  9. Exit MySQL:

    exit;

← MySQL