Sometimes mysql cannot be started when we install the mysql software, or mysql may not run after the server security settings.
Sometimes mysql cannot be started when we install the mysql software, or mysql may not run after the server security settings.
After configuring MySQL 5.1.48 or MySQL 5.5.8, click Execute, but the Start service step is not completed. 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' registry as a storage engine failed.
Unknown/unsupported table type: INNODB
It turns out that the two versions of MySQL use the INNODB engine that supports transactions by default, open the my. ini file, and in the MySQL installation folder, such as c: program filesMySQL, you can see:
Default-storage-engine = INNODB
The solution is to change this setting
Default-storage-engine = MYISAM
Still use MyISAM as the default database engine, save the my. ini file, start the MySQL service manually, and 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 recall the configuration process again:
In the last step of installation, When you click Finish, you can select Configure the MySQL Server now, or directly run MySQL Server Instance Configuration Wizard 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
Default is the first option. If you select the second option, the default engine of the database is INNODB. The generated my. 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
If the problem persists, refer to the following method:
The service cannot be started when MySQL is installed)
1. We recommend that you use 360 to uninstall the installed mysql database, because 360 will view the relevant registration information and uninstall the database thoroughly.
2. Check whether port 3306 is occupied. If it is occupied, kill the process.
3. check whether there are mysql service processes in the service list.
4. Make sure that the access permission to the installation directory is everyone. Here, we recommend that you do not include the C drive installed in mysql, because xp sometimes restricts the access permission to folders for system security.
5. It is recommended to install the file in a clean folder. If the file is installed in the folder that was last installed, delete all files in the folder.
Mysql cannot run after mysqlWe recommend that you reset the login username and password for running the mysql service, and enter the username and password you just modified in the service.
If the problem persists, you can view the error log to solve the problem:
The mysql error log is located in the. err file under the mysql installation directory. copy a file and use notepad or another tool to open it. If the err log is too large, we recommend that you do not use NotePad to open it with editplus.
