Setting up a forced-innoDB database in phpMyAdmin?

[LiquidFractal]

Is it possible to configure a database from its creation to use only innoDB tables, even if 3rd-party Invision apps/plugins want to create myISAM?

[Lucas James]

You need to edit the /etc/my.cnf file with following parameter under the [mysqld] section:

default-storage_engine=innodb

Save the file and restart MySQL/MariaDB.

[LiquidFractal]

8 hours ago, Lucas James said:

You need to edit the /etc/my.cnf file with following parameter under the [mysqld] section:

default-storage_engine=innodb

Save the file and restart MySQL/MariaDB.

Thank you Lucas.  But can you tell me if this will also prevent myISAM tables from being written through the installation of 3rd-party apps/plugins (I ask because the variable mentions "default" storage engine)?  And if so, might this prevent their installation or compromise their function?

Edited September 9, 2021 by liquidfractal

[Nathan Explosion]

 

[Marc]

7 hours ago, liquidfractal said:

Thank you Lucas.  But can you tell me if this will also prevent myISAM tables from being written through the installation of 3rd-party apps/plugins (I ask because the variable mentions "default" storage engine)?  And if so, might this prevent their installation or compromise their function?

tables are created using the default storage engine, so switching that will indeed have the desired effect