After MySQL 5 is installed, it cannot be started (cannot Start service ).

After MySQL 5 is installed, you cannot Start service to fix MySQL 5.1.48 or MySQL 5.5.8. After the configuration is completed, click Execute, but you cannot Start service. Check that the MySQL System Service has been added but cannot be started. At this time, we can use the Event Viewer to see several MySQL errors in the Program Event: Plugin 'innodb' registration as a storage engine failed. unknown/unsupported table type: INNODB was originally used because MySQL of these two versions use the INNODB engine that supports transactions by default. Open my. ini file, in the MySQL installation folder, such as c: program filesMySQL, you can see: default-storage-engine = INNODB the solution is to change this setting to www.2cto.com default-storage-engine = MYISAM and still use MyISAM as the default database engine. Save my. ini file, and then start the MySQL service manually. Then, close the Configuration window. You can specify the database engine used to create the database, the database engine used to create the table, or change it after the database is created. You can repeat the configuration process again: the last step of installation. When you click Finish, you can select Configure the MySQL Server now, or run MySQL Server Instance Configuration Wizard of MySQL in the Start menu to configure the database. When selecting Database usage, there are three options: 1) Multifunctional Database 2) Transactional database Only 3) no-Transactional Database Only www.2cto.com is the first item by default. If you select the second item, the default engine of the Database is INNODB. the ini file contains default-storage-engine = INNODB. If you comment out -- skip-innodb in my. ini, it does not affect the database startup, but it only determines the transaction characteristics of the database. In the last step, Processing configuration... my. after the ini file is started, the Start service will not work, that is, the MySQL service cannot be started, and the MySQL service name has been added to the system service. If you select the third item in this step and do not use a database that supports events. the ini file contains default-storage-engine = MYISAM, so you are lucky to be able to smoothly configure and start the database. However, this will prevent you from using the INNODB engine (ERROR 1286 (42000): Unknown table engine 'innodb. the skip-innodb in ini is enabled. you can comment it out and try it again. Author: mywaylife