To set the default engine as the InnoDB mysql

1. view the location mysql arsenal engine : mysql> show engines. InnoDB | YES,GHD Green Butterfly 2011, explain the mysql database waiter assists InnoDB engine. 2. set InnoDB as the default engine: in the configuration file my.cnf in the [mysqld] join the emulating default-storage-engine = INNODB3. restart the mysql waiter 4. login mysql database ,GHD, mysql> show engines. If InnoDB | DEFAULT,GHD Deluxe Midnight 2011, then namely set InnoDB as the default engine success.