HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMajor

How can I change the default storage engine in phpmyadmin?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
enginecanthestoragephpmyadmindefaulthowchange

Problem

I use InnoDB almost exclusively in my applications. However, if I'm not careful when setting up the table, I forget to change it and phpmyadmin sticks me with MyISAM. Is there a way to change the default storage engine?

Solution

You have to add the line default-storage-engine = InnoDB under the [mysqld] section of your mysql config file (my.cnf or my.ini depending on your operation system) and restart the mysqld service.

I don't believe you can change this through PhpMyAdmin.

Context

StackExchange Database Administrators Q#96, answer score: 25

Revisions (0)

No revisions yet.