Mysql InnoDB database

All of my tables are InnoDB but PHPMyAdmin shows that the database is MyIsam: http://img708.imageshack.us/i/201103080940551280x800s.png/ How do I create new MySQL databases using InnoDB? Running MySQL 5.1, in a Debian Sid box. Thank you开发者_运维问答.

AFAIK it is showing MyISAM because that is your default storage engine on that database, i.e. if you were to create a new table and not specify the engine then it would be MyISAM.

You can change the default storage engine in your my.cnf file:

default-storage-engine=INNODB

Use MySQL Workbench for GUI interface: http://wb.mysql.com/

You can it directly using SQL also:

ALTER TABLE products ENGINE = innodb