How do I determine the default MySQL Storage Engine?
-
Open MAMP PRO and start the servers.
-
Open Terminal (
/Applications/Utilities/Terminal.app). -
Change to the MySQL binary directory:
cd /Applications/MAMP/Library/bin -
Connect to the MySQL server:
./mysql --host=localhost -u root -proot -
Select the
information_schemadatabase:USE information_schema; -
Query the storage engines:
SELECT * FROM engines; -
In the result table, look for the row in the Support column with the value
DEFAULT— that is the active default storage engine. -
Exit the MySQL prompt:
exit;