How to make innodb as default engine

I am trying to make Innodb as my default engine and I changed this in the my.cnf file.

I set default-storage-engine=InnoDB in 开发者_如何学Gomy.cnf file and restarted mysql but still it's not taking it.

Even after restarting the server, it's still showing default engine as MyISAM.

show engines

+------------+---------+-

| Engine | Support |

+------------+---------+-

| InnoDB | YES |

| MRG_MYISAM | YES |

| BLACKHOLE | YES |

| CSV | YES |

| MEMORY | YES |

| FEDERATED | NO |

| ARCHIVE | YES |

| MyISAM | DEFAULT |

+------------+---------+-

How can I change it to InnoDB ?

---

Make sure you add this line in the proper section of the my.cnf file. It needs to be in the [mysqld]section:

default-storage-engine=InnoDB

Also, comment out any other line in my.cnf that may be setting it to MyISAM.