FAQ

How do I check the Default Storage Engine of MySQL?

  1. Open MAMP
  2. Start the servers
  3. Open Terminal.app located in the “/Applications/Utilities” directory.
  4. Enter the following line into the terminal and hit Enter
    cd /Applications/MAMP/Library/bin
  5. Enter the following line into the MySQL prompt 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;