Enabling InnoDB in XAMPP
InnoDB is not enabled in XAMPP's MySQL installation by default. This walkthrough shows you how to enable InnoDB on your copy of XAMPP.
- Find and open your my.cnf file (MySQL configuration file). The location depends on your operating system; take a look at the section below to find out. Note that the extension may be hidden in Windows, so the file may be called "my".
- If there is a skip-innodb line, precede it with a "#" (hash) character to comment it out.
- Uncomment (i.e., remove the "#" character from) all lines beginning with innodb_.
- Save your my.cnf file.
- Restart MySQL using the XAMPP Control Panel.
MySQL Configuration Location
| OS | Location |
|---|---|
| Windows | C:\xampp\mysql\bin\my.cnf |
| Mac OS X | /Applications/xampp/etc/my.cnf |