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