Shulou(Shulou.com)05/31 Report--

This article mainly introduces "Why can't start after installing MySQL5". In daily operation, I believe many people have doubts about why they can't start after installing MySQL5. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the question of "why can't start after installing MySQL5?" Next, please follow the editor to study!

Install MySQL 5.1.48 or MySQL 5.5.8, and finally click the Execute button when configured, but you can't do Start service. Check that the MySQL system service has been added, but it cannot be started, not even manually. At this point, using the event viewer, you can see that there are several errors from MySQL in the program event:

Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Unknown/unsupported table type: INNODB

It turns out that these two versions of MySQL use the INNODB engine that supports things by default. Open the my.ini file, and in the installation folder of MySQL, such as c:program filesMySQL, you can see:

Default-storage-engine=INNODB

The solution is to change the setting to

Www.2cto.com

Default-storage-engine=MYISAM

Still use MyISAM as the default engine, save the my.ini file, and then start the MySQL service manually, successfully; just close the configuration window.

You can specify the database engine used to create the database when you create the database, or the database engine used to create the table, or change it after you create it.

You can recall the process that you just configured:

For the last step of installation, when you click the Finish button, you can select Configure the MySQL Server now, or run MySQL's MySQL Server Instance Configuration Wizard directly from the start menu to configure the database. There are three options when selecting database usage:

1) Multifunctional Database

2) Transactional Database Only

3) No-Transactional Database Only

Www.2cto.com

The default is the first item, and selecting the second option will also make the default engine of the database INNODB, and the generated my.ini file will be default-storage-engine=INNODB. As for commenting out in my.ini-skip-innodb doesn't really affect the startup of the database, it just determines the transaction nature of the database.

So in the last step, Processing configuration... After writing the my.ini file, the Start service will not move, that is, the MySQL service cannot be started, and the MySQL service name has been added to the system service.

If you choose the third option in this step and do not use the database that supports events, then it is default-storage-engine=MYISAM in the my.ini file, then you are lucky to be able to successfully configure and start the database. However, this will prevent you from using the INNODB engine (ERROR 1286 (42000): Unknown table engine 'InnoDB'), which means enabling skip-innodb in my.ini, which you can comment out and try things again.

At this point, the study on "Why can't start after installing MySQL5" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.