MAMP PRO (macOS) Documentation

FAQ > MySQL

How do I determine the default MySQL Storage Engine?

1. Open MAMP PRO
2. Start the servers
3. Open Terminal.app (/Applications/Utilities)
4. Enter the following line into the terminal and hit enter:
   cd /Applications/MAMP/Library/bin
5. Enter the following line into the terminal and hit enter:
   ./mysql --host=localhost -u root -proot
6. Enter the following line into the MySQL prompt and hit enter:
   USE information_schema;
7. Enter the following line into the MySQL prompt and hit enter:
   SELECT * FROM engines;
8. A table with the Storage Engines of MySQL will show up. Inside the Support column the Default Storage Engine has the value DEFAULT.
9. Enter the following line into the MySQL prompt and hit enter:
   exit;