[mysql] InnoDB storage engine is not supported

MySQL is capable to store data in a variety of formats. The default format is MyISAM which offers performance and it is used by most web services. InnoDB is transactional and it is used in heavy environments thanks to row-level locking.

Last days I tried to install a PHP application on server and I got the error "InnoDB storage engine is not supported".

To enable InnoDB – follow these steps:

Alter my.cnf and comment the line



Restart mysql

/etc/init.d/mysql restart


You can check if InnoDB storage engine is enabled by simply querying the MySQL:

mysql> show variables like 'have_inno%';
| Variable_name | Value |
| have_innodb   | YES   |
1 row in set (0.00 sec)