How to set default storage engine

How to set default storage engine

If you are looking for how to set default storage engine on Linux no matter the LAMPP setup read below.

If you are running Xampp (Lampp on Linux –> apachefriends.org) all you need to do is to edit /opt/lampp/etc/my.cnf and add after [mysqld] the following line:

default-storage-engine=InnoDB

If you want to use MyISAM just alter the line:

default-storage-engine=MyISAM

and then restart mysql

Back to top