Unknown/unsupportedtabletype: innodb

For example, this problem occurs when MySQL is started when a new system is installed. It turns out that InnoDB engine is not installed when MySQL is installed. The solution is as follows: 1. change the default engine back to MyISAM and modify etcmy. cnf: Comment the whole line of -- default-storage-engine or change it to MyISAM. 2. Start MySQL. If there are no other errors

For example, this problem occurs when MySQL is started when a new system is installed. It turns out that InnoDB engine is not installed when MySQL is installed. The solution is as follows: 1. change the default engine back to MyISAM and modify/etc/my. cnf: Comment the whole line of -- default-storage-engine or change it to MyISAM. 2. Start MySQL. If there are no other errors

For example, this problem occurs when MySQL is started when a new system is installed today. It turns out that InnoDB engine is not installed when MySQL is installed, and thus it does not recognize it. The solution is as follows:

1. Change the default engine back to MyISAM, modify/etc/my. cnf, comment the whole line of -- default-storage-engine, or change the value to MyISAM.

2. Start MySQL. If there are no other errors, it should be able to start successfully.

3. log on to MySQL and run the following command: # mysql-uroot-p (enter your password)

4. install the InnoDB engine with the command: # install plugin innodb soname 'Ha _ innodb. so ';

5. You can see that the installation is successful. Exit MySQL, re-edit/etc/my. cnf, and set -- default-storage-engine = InnoDB

6. Restart MySQL. Now it is successful!