Unable to start of after installing MySQL 5 cannot Start service solution summary

  • 2020-05-13 03:40:20
  • OfStack

MySQL 5.1.48 or MySQL 5.5.8 installed, configured and finally hit the Execute button, but not Start service. I checked that the MySQL system service has been added, but it could not be started, even manually. At this point, the event viewer can see that there are several errors in the program event from MySQL:

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 MySQL installation folder, c:program filesMySQL, you can see:

default-storage-engine=INNODB

The solution is to change this setting to

default-storage-engine=MYISAM

Still using MyISAM as the default database engine, save the my.ini file and manually start the MySQL service, successful; Just close the configuration window again.

You can specify which database engine you want to use when creating a database, which database engine you want to use when creating a table, or which database engine you want to change after creating a database.

You can recall again the process you just configured:

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

1) Multifunctional Database
2) Transactional Database Only
3) No-Transactional Database Only

The default is item 1. If you select item 2, you will also make the database engine INNODB by default, and the generated my.ini file will be default-storage-engine =INNODB. As for the comment out in my.ini -- skip-innodb doesn't really affect database startup, it just determines the properties of the database.

So at the last step, Processing configuration... After writing the my.ini file in the system, Start service will not be activated, which means that the MySQL service cannot be started. The MySQL service name has been added to the system service.

If you choose item 3 in this step and do not use the database that supports events, then default-storage-engine =MYISAM in the my.ini file, then you are also lucky to have successfully configured and started the database. However, this will prevent you from using the INNODB engine (ERROR 1286 (42000): Unknown table engine 'InnoDB'), essentially enabling skip-innodb in my.ini, which you can comment out again to try things out.

The author mywaylife

If you still can't solve it, you can refer to the following methods:

Unable to start the service while installing MySQL (could not start the service)

1. It is recommended to use 360 to uninstall the installed mysql database, because 360 will check the relevant registration information and uninstall it completely.
2. Check whether port 3306 is occupied, and if so, kill the process.
3. Check the service list to see if there is still the service process of mysql.
4. Make sure that the access right of the installation directory is everyone. Here, I suggest not to install the c disk of mysql, because xp sometimes limits the access right of folders for the sake of system security.
5, it is recommended to install in a clean folder, if installed in the folder installed last time, it is recommended to delete all files under the folder.

After mysql security setting, mysql cannot run. It is recommended to reset the login user name and password of mysql service, and then enter the user name and password just changed into the service again, so that it is ok

If it still doesn't work, we can fix it by looking at the error log:

The mysql error log is located in the mysql installation directory with the extension.err. Make a copy of the file and open it with notepad or other tools

Related articles: