How to enable InnoDB to start on startup

[eLight]

To check if InnoDB is already running/is running after changes, in MySQL run:

show engines;

InnoDB should be in the list with no problems. Support = "YES".

eLight Reviewed by eLight on 26th Jul 2011. How to enable InnoDB to start on startup If InnoDB isn't starting up on start up then navigate to the /etc folder. In there open up with your favourite editor, the file 'my.ini' or 'my.cnf'. Or for short: nano /etc/my.cnf Once you are in there search for 'skip-innodb'. If it is there then delete the line & restart MySQL: Rating: 5

[Enzyme]

Do you not have to type 'mysql' first? Type 'show engines;' then Pause Break to come out of 'mysql'?

[madaboutlinux]

Yes, show engines; need to be executed on the mysql server prompt and then come out of it.

BTW, the easy way to check if innodb is enabled is to execute the following without entering the mysql prompt

mysqladmin variables | grep have_innodb

You may need to provide mysql username/password as per your mysql configuration.

mysqladmin variables -u<user> -p<password> | grep have_innodb

[Enzyme]

You learn something new everyday .