How to set InnoDB as a default storage engine for MySQL tables

I use InnoDB storage engine because of support for transactions and referral integrity rules. However, MySQL still creates new tables as MyISAM by default. It was so annoying ┬áto always define storage engine when creating new tables and double check that I didn’t forget it until I found how to set InnoDB by default.

Read more